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).

Copyright © 2020-2025 Systematic Solutions, LLC