Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count most common answer.
I have 3 columns of 24 cells headed 'gold' 'silver' and 'bronze'. each of the
24 cells could have 1 of 5 answers depending on other calculations elsewhere on the sheet. What function can I put into cell 25 of each column to count to most common name? Or to put it another way, to see who won most golds, silvers and bronzes out of the 5 people? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
COUNT COMMON DATA | Excel Worksheet Functions | |||
count text values and return most common occurence | Excel Discussion (Misc queries) | |||
count # of instances in cell (a b a) answer 2 formula if possible | Excel Worksheet Functions | |||
Table to pick out most common entries and count occurences of each | Excel Worksheet Functions | |||
Count unique alpha numeric "characters" in a common cell | Excel Worksheet Functions |