Ever need to find out which value in your data set occurs most frequently?

Yes I have as well more often than I thought I wold when I learned this Excel tip. Well here is a really easy way to do it. Using the MODE function. Lets start with and example- I have a data set in my workbook MY_DATA.

The syntax of the function is

=MODE(MY_DATA)

This will return the value 123 as it occurs the most often in my data set.

 

 

 

 

 

 

 

 

 

 

 

 

Let’s take this even further and count the number of times the most frequently occurring value appears in the range i.e the frequency of the mode. The syntax of this is-

=COUNTIF(MY_DATA,MODE(MY_DATA))

This will return 4 as the modal value (123) appears four times in MY_DATA range.

MODE only works for numeric values and it will ignore cells that contains text.