View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Skalp Skalp is offline
external usenet poster
 
Posts: 2
Default Second Most Common Value

I know that I can find the most common value in a group of numbers with MODE
function. But is this possible to find the second most common value in the
same group of numbers. It mustn't be with the same function, I just want to
get 3 most common values from one and the same group of numbers so that i
dont have to delete any numbers. I mean not so that i find the most common
value, delete all those values and then will get second most common value.
No. I want all numbers to stay.