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!

Continuance of last post on highest #
 

Try this array formula** :

Assuming you enter this formula in F12.

=INDEX(D$12:D$30,MATCH(LARGE(C$12:C$30-ROW(C$12:C$30)/10^10,ROWS(F$12:F12)),C$12:C$30-ROW(C$12:C$30)/10^10,0))

Copy down as needed

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP


"Randy" wrote in message
...
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!

Continuance of last post on highest #
 

Thank-you unfortunately it returns the result "N/A". The formula looks good
but it does not bring back the result. Thx for the help any new ideas would
be greatly appreciatted

"T. Valko" wrote:

Try this array formula** :

Assuming you enter this formula in F12.

=INDEX(D$12:D$30,MATCH(LARGE(C$12:C$30-ROW(C$12:C$30)/10^10,ROWS(F$12:F12)),C$12:C$30-ROW(C$12:C$30)/10^10,0))

Copy down as needed

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP


"Randy" wrote in message
...
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!

Continuance of last post on highest #
 

Try this array formula** :
** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

Did you enter the formula as an array? It works. Trust me!


--
Biff
Microsoft Excel MVP


"Randy" wrote in message
...
Thank-you unfortunately it returns the result "N/A". The formula looks
good
but it does not bring back the result. Thx for the help any new ideas
would
be greatly appreciatted

"T. Valko" wrote:

Try this array formula** :

Assuming you enter this formula in F12.

=INDEX(D$12:D$30,MATCH(LARGE(C$12:C$30-ROW(C$12:C$30)/10^10,ROWS(F$12:F12)),C$12:C$30-ROW(C$12:C$30)/10^10,0))

Copy down as needed

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP


"Randy" wrote in message
...
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!

Continuance of last post on highest #
 

Screencap:

http://img146.imageshack.us/img146/3742/sortus9.jpg

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
Try this array formula** :
** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

Did you enter the formula as an array? It works. Trust me!


--
Biff
Microsoft Excel MVP


"Randy" wrote in message
...
Thank-you unfortunately it returns the result "N/A". The formula looks
good
but it does not bring back the result. Thx for the help any new ideas
would
be greatly appreciatted

"T. Valko" wrote:

Try this array formula** :

Assuming you enter this formula in F12.

=INDEX(D$12:D$30,MATCH(LARGE(C$12:C$30-ROW(C$12:C$30)/10^10,ROWS(F$12:F12)),C$12:C$30-ROW(C$12:C$30)/10^10,0))

Copy down as needed

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP


"Randy" wrote in message
...
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!

Continuance of last post on highest #
 

excellent thank-you. I am so happy!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

"T. Valko" wrote:

Screencap:

http://img146.imageshack.us/img146/3742/sortus9.jpg

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
Try this array formula** :
** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

Did you enter the formula as an array? It works. Trust me!


--
Biff
Microsoft Excel MVP


"Randy" wrote in message
...
Thank-you unfortunately it returns the result "N/A". The formula looks
good
but it does not bring back the result. Thx for the help any new ideas
would
be greatly appreciatted

"T. Valko" wrote:

Try this array formula** :

Assuming you enter this formula in F12.

=INDEX(D$12:D$30,MATCH(LARGE(C$12:C$30-ROW(C$12:C$30)/10^10,ROWS(F$12:F12)),C$12:C$30-ROW(C$12:C$30)/10^10,0))

Copy down as needed

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP


"Randy" wrote in message
...
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!

Continuance of last post on highest #
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Randy" wrote in message
...
excellent thank-you. I am so happy!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

"T. Valko" wrote:

Screencap:

http://img146.imageshack.us/img146/3742/sortus9.jpg

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
Try this array formula** :
** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

Did you enter the formula as an array? It works. Trust me!


--
Biff
Microsoft Excel MVP


"Randy" wrote in message
...
Thank-you unfortunately it returns the result "N/A". The formula looks
good
but it does not bring back the result. Thx for the help any new ideas
would
be greatly appreciatted

"T. Valko" wrote:

Try this array formula** :

Assuming you enter this formula in F12.

=INDEX(D$12:D$30,MATCH(LARGE(C$12:C$30-ROW(C$12:C$30)/10^10,ROWS(F$12:F12)),C$12:C$30-ROW(C$12:C$30)/10^10,0))

Copy down as needed

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER)

--
Biff
Microsoft Excel MVP


"Randy" wrote in message
...
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!