baseball stats spreadsheet help

[Stephen Anderson]

I really do not know how ask this question but
I'll try to attempt it...

I'm trying to build a spreadsheet of softball
stats and am trying to use a table of hitting
averages and extracting the data for another
table of best to worst hitters..

First I pull the largest to smallest averages
from the table using:

=LARGE(C27:C44,1)
=LARGE(C27:C44,2)
=LARGE(C27:C44,3)
..
..
..
=LARGE(C27:C44,16)

then I attempt to pull the player's name using:

=ADDRESS(MATCH(E5,$C$27:$C$44,0)+26,2,1,0)
=ADDRESS(MATCH(E6,$C$27:$C$44,0)+26,2,1,0)
=ADDRESS(MATCH(E7,$C$27:$C$44,0)+26,2,1,0)
..
..
..
=ADDRESS(MATCH(E20,$C$27:$C$44,0)+26,2,1,0)

and redirecting the result into another table via:

=INDIRECT(G5,FALSE)
=INDIRECT(G6,FALSE)
=INDIRECT(G7,FALSE)
..
..
..
=INDIRECT(G20,FALSE)

My problem is that there is duplicate results in
the original table, the same name is displayed
because only the first occurrence is captured when
using the MATCH function.

Can anybody point me in the right direction on how
to get around the duplicate data?

Original Table New Table
---------------- ------------
Barnsie 0.332 Barnsie 0.332
Charlie 0.191 Barnsie 0.332 <= Dave
Chris 0.099 Perry 0.322
Dave 0.332 Rob2 0.267
Jeff 0.158 Pat 0.252
Pat 0.252 Rob 0.211
Perry 0.322 Charlie 0.191
Rob 0.211 Jeff 0.158
Rob2 0.267 Steve 0.156
Steve 0.156 Chris 0.099

Thanks...

Steve

 

[Don Guillett]

I found this using Ron DeBruin's google search addin
http://www.rondebruin.nl/

http://tinyurl.com/yrcvm

 

[Chip Pearson]

Stephen,

See www.cpearson.com/excel/rank.htm for some possible solutions.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Stephen Anderson]

Thanks Chip... excellent article.

I'm sure the RANK function listed here will solve
my problem. Didn't expect a solution that fast.

Steve