View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike Archer Mike Archer is offline
external usenet poster
 
Posts: 52
Default Most common occurrence of a string

Hello.
I need a worksheet function that will tell me the most frequent occurrence
of a single character string in a range of cells, the second most, and the
third most.
Example
A B C D E F
1
2 A A B B A C
3
4 1st 2nd 3rd
5 A B C

So a formula in A5 that gives the most common occurrence in range A2:F2. A
formula in B5 that gives the second most frequent occurence and a forumula in
C5 that gives the 3rd.


--
Thanks,
Mike