MODE

Returns the most frequently occuring 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 occurences.

Additional Comments

When two values have the same number of occurences, 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