Home Excel Tips and Tricks How To Calculate Modal In Excel

How To Calculate Modal In Excel

The modal is the number that mostly appear. We are going to learn how to calculate the modal, with these simple steps.

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

data

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.

formula

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

You can download the Template here – Download

Further reading: 
Basic concepts 
Getting started with Excel
Cell References