MODE function


Returns the most frequently occurring value.



=MODE( number1[number2], …)


required arguments:

number1 The first value.


optional arguments:

[number2] The second optional value.

Skillshare’s usually $10 a month, but because you’re an OfficeTuts reader you can get your first month free by clicking here. That’s unlimited access to over 18,000 classes on Excel, VBA, and much more.