R
Randy
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!
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!