Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
count array for top three entries and return their number
I am trying to solve a scoring problem for a car show.
In a spread sheet we will have entry number of cars running across columns that represent individual 1st place choices. Without filtering and resorting the data (no time at the car show) I need to dynamically determine the top three entires and return the number of times they show up. I.E if these are the car entry numbers in their respective columns. 1 2 1 3 2 4 2 4 1 1 1 4 2 Should return 1 5 2 4 4 3 I don't even need the second number (number of votes, but we probably need it to verify the formula is working). Thanks!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I count the number of entries of specifc criteria is met | Excel Worksheet Functions | |||
Count, number of entries of a particular month. | Excel Worksheet Functions | |||
count the number of cell entries after filtering | Excel Discussion (Misc queries) | |||
How can I count the number of entries in a column? | New Users to Excel | |||
Count number of different entries? | Excel Worksheet Functions |