ExcelFlux

MODE function

the most common value in a data set.

Compatibility · Guided Excel example

Where can you use it?

Teams maintaining legacy workbooks. Compare the example inputs and expected results with the formula in your workbook when checking a calculation made in an older version.

Scenario in the workbook

Find the most frequent quantity using the legacy MODE function. MODE.SNGL is the modern counterpart.

A worked example from the workbook

RowABC
6InputSecond inputThird input
7337
8122
9899
Record 1
=MODE(A7:C7)

Illustrative output3

See the inputs and instructions for all 3 examples

Compatibility function for older workbooks.

Worked examples

Find the most frequent quantity using the legacy MODE function. MODE.SNGL is the modern counterpart.

Column F provides expressions as text. Satisfy the stated requirements, then paste into an empty Excel cell and compare with column G. The result was not verified in desktop Excel here.

Row A B C
6 Input Second input Third input
7 3 3 7
8 1 2 2
9 8 9 9
Trial Expression Sample output
Record 1 =MODE(A7:C7) 3
Record 2 =MODE(A8:C8) 2
Record 3 =MODE(A9:C9) 9
Microsoft Excel reference