Hints and tips home » Excel hints and tips » Using Excel's MODE function

Using Excel's MODE function

Use Excel's MODE function to display the most common value present in a particular range of cells.

The Mode function looks like this:

=MODE(cell range)

As an example, if 35 is the most commonly recurring number in a particular cell range, then the function will display 35.

Added by Amanda on 26th November 2006

More Excel hints and tips, like:

• Use RANDBETWEEN to generate random numbers
• Creating a range of monthly payments as text
• No Zeros