Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Continuance of last post on highest #
I received the following formula to solve my excel problem. Thiis formula
worked fine with the exception when two numbers were identical the result was always the first name. Formula:INDEX($D$12:$D$20,MATCH(LARGE($C$12:$C$20, 1),$C$12:$C$20,0)) The results below analyze the info at first and results on bottom, problem is i need each player identified even if they are tied. Can anyone help me, forever in your debt. Analyze to find highest total rankings from top to bottom: Goals ## Rogers 11 Bowdy 13 Anderson 4 Smith 16 Nagel 10 Cohagen 7 Cooper 1 1 Preist 32 O'Brien 20 Zacharias 55 O'Brien 19 Wall 17 Edmonds 8 Minardo 6 Marietti 2 Hoover 53 Ridgway 3 1 Rogers 0 Eberhart 0 Results from formula Goals ## Zacharias 55 Hoover 53 Preist 32 O'Brien 20 O'Brien 19 Wall 17 Smith 16 Bowdy 13 Rogers 11 Nagel 10 Edmonds 8 Cohagen 7 Minardo 6 Anderson 4 Ridgway 3 Marietti 2 Cooper 1 Cooper 1 Cooper 1 Rogers 0 Rogers 0 As you see here if two players of a different name have the same total it still puts the first player it sees in all the results. Any ideas? I hope! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display the Highest, Second Highest, Third Highest and so on... | Excel Discussion (Misc queries) | |||
2 rows, highest No in row 1, then highest number in row 2 relating to that column, possible duplicates | Excel Worksheet Functions | |||
This is my Third Post Please Help !!!!!! | Excel Discussion (Misc queries) | |||
post | Excel Discussion (Misc queries) | |||
Should I generally request "post a poll" when I post a new thread? | Excel Discussion (Misc queries) |