Thread: Multiple Modes?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Multiple Modes?

Look up the FREQUENCY function in help.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Gaeza" wrote in message
...
I cant figure out how to get, let's say the top 10 recurring values for a
very large set of data. I need to know which values occur most frequent.
I
have been able to get the mode but not the top ten modes. Your help will
be
appreciated. Thanks!