Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Display common values in first occurrence only | Excel Discussion (Misc queries) | |||
Occurrence between rows | Excel Discussion (Misc queries) | |||
V Lookup 2nd Occurrence | New Users to Excel | |||
find last occurrence | Excel Worksheet Functions | |||
occurrence (last) reference | Excel Discussion (Misc queries) |