Skip to content
Adaptam Docs

MIN_TEXT

Minimum (alphabetically first) text value in cells, ranges, or data fields. Non-text values (numbers, dates, blanks/empty cells, Booleans, errors) are ignored. Comparison is case-insensitive.

Function syntax

MIN_TEXT(input1, ...)

Arguments:

  • input1, …: One or more text values, cells, ranges, or data fields.

Examples

  • MIN_TEXT(A1:A3) - If A1:A3 contains Zebra, Apple, Mango, returns Apple.
  • MIN_TEXT(country{}) - Alphabetically first value in the country field.
  • MIN_TEXT(product{category{“Electronics”}}) - Alphabetically first product where category is Electronics.
  • MIN_TEXT(country{}, A1:A10) - Alphabetically first text across the country field and cells A1:A10 combined.
  • MIN_TEXT(A1:A4) - If A1:A4 contains Zebra, 100, Apple, Mango, returns Apple. Numbers are ignored.