What Does It Do ?
This function displays the most frequently occurring number in a group of numbers.
For it to work correctly there must be at least two numbers which are the same.
If all the values in the group are unique the function shows the error #N/A.
When there is more than one set of duplicates, the number closest to the beginning of the group will be used. (Which is not really an accurate answer!)
Syntax
=MODE(Range1,Range2,Range3... through to Range30)
Formatting
No special formatting is needed.
No comments:
Post a Comment