Find top 10 scores

[Guest]

My data is arranged as below with 40 columns
Com-a Com-b Com-c Com-d .....Com....... 40 columns
-1.542 -4.628 -6.607 -1.831
3.127 0.772 0.717 4.108
7.002 6.805 7.009 8.706
9.364 10.169 7.826 10.396
4.169 4.117 0.337 5.087
I need to select the top 10 scores in the last row and report this along
with the column heading for identification.

Thanks

 

[Myrna Larson]

=LARGE(A5:AP5,n) will give you the nth largest value in row 5. Replace "n"
with a number between 1 and 10.

=INDEX(A1:AP1,MATCH(LARGE(A5:AP5,n),A5:AP5,0)


On Mon, 22 Nov 2004 10:57:03 -0800, "John Terry" <John

 

[Guest]

Thanks Myrna. It works!

=LARGE(A5:AP5,n) will give you the nth largest value in row 5. Replace "n"
with a number between 1 and 10.

=INDEX(A1:AP1,MATCH(LARGE(A5:AP5,n),A5:AP5,0)


On Mon, 22 Nov 2004 10:57:03 -0800, "John Terry" <John