MODE

MODE first most common number in the dataset

Synopsis

MODE(number1,number2,…)

Arguments

number1: first value

number2: second value

Description

Strings and empty cells are simply ignored.

If the data set does not contain any duplicates this function returns a #N/A error.

Microsoft Excel Compatibility

This function is Excel compatible.

See also

AVERAGE, MEDIAN.