Skip to content
Adaptam Docs

MODE

Most frequent value in cells, ranges, or data fields. Blanks are ignored.

Function syntax

MODE(input1, ...)

Arguments:

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

Examples

  • MODE(C4:C14) - Most frequent value in C4:C14.
  • MODE(status{}) - Most frequent value in the status field.
  • MODE(status{region{“West”}}) - Most frequent status value where region is West.
  • MODE(status{}, C10:E15) - Most frequent value across the status field and the range C10:E15 combined.
  • MODE(A1:A4) - If A1:A4 contains 1, 1, 2, 2, returns 1. When tied, returns the first occurring value.
  • MODE(A1:A4) - If A1:A4 contains 1, blank, blank, blank, returns 1. Blanks, though more frequent, are ignored.
  • MODE(A1:A5) - If A1:A5 contains "red", 5, "red", 10, "red", returns “red”. Works across all data types.