MODE

Returns the most frequently occurring value in the specified list of amounts.

Formula syntax

MODE(Amount #1, Amount #2, Amount #3, ...)

Amounts: items being evaluated to determine which has the highest number of occurrences.

Additional comments

When two values have the same number of occurrences, the first value in the list is the value that is returned.

Examples

MODE(1, 2, 2, 3, 4) equals 2

MODE(1, 2, 3, 3, 4, 4) equals 3

PensionSoft Corporation | 860.540.3690 | support@pensionsoft.com