View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK
 
Posts: n/a
Default Mode - getting bi- and multi-modal results??

You could add this formula to D2:

=COUNTIF(A$2:A$10,C2)

and copy it down to give you a count of each of the numbers in C.
Doesn't answer your question, but useful nonetheless.

Pete