Category
General-Purpose Functions
Description
Nth largest of a group of values
Syntax
MaxN(N, value1, value2, ...)
Parameters
N - number from 1 to count of values
value1 - any formula
value2 - any formula
... - any number of additional comma-separated formulas
Notes
This function evaluates each of the formulas passed to it and returns the Nth largest value found.
MaxN(1, value1, value2) is the same as Max(value1, value2).
|