Excel Modal Calculation: Most Frequent Value

How To Calculate Modal In Excel

Spread out the numbers in the same role, for your convenience.

Note: The spread numbers should have at least 2 numbers that are the same.

Click on a blank column, and type in =MODE(choose all the columns with numbers ex a5:a15), and then press enter. In this case, 4 is the modal.

Note: Use =Mode.Mult(columns ex. C1:C34) if there are more than two modals.

Modal formula in this example is

=MODE(A1:A10)

Template

Further reading: 
Basic concepts 
Getting started with Excel
Cell References