Thread: Mode function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Tyro[_2_] Tyro[_2_] is offline
external usenet poster
 
Posts: 1,091
Default Mode function

MODE does not return the largest value. It returns the most frequently
occurring, or repetitive, value in an array or range of data. If more than
one value meets the criterion, MODE returns the first value that does.

Tyro



"Guy Lydig" wrote in message
...
Why does the MODE function return only the largest value if an array of
numbers has more than one mode? How can I get it to return all the modes?

TIA

Guy