Skip to content
Adaptam Docs

MAX_TEXT

Maximum (alphabetically last) 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

MAX_TEXT(input1, ...)

Arguments:

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

Examples

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