D
DClark5412
Can anyone help me find a function in excel that will find the top ten
highest scores in my data?
highest scores in my data?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
CLR
Try Data > Filter > AutoFilter, and select the "Top 10" option from the drop
down arrow in the column of interest.
Then, Data > Filter > AutoFilter again to revert to showing all data
again.....
Vaya con Dios,
Chuck, CABGx3
down arrow in the column of interest.
Then, Data > Filter > AutoFilter again to revert to showing all data
again.....
Vaya con Dios,
Chuck, CABGx3
B
Bob Phillips
=LARGE($A$1:$A$100,ROW(A1))
and copy down for 9 more cells
--
HTH
RP
(remove nothere from the email address if mailing direct)
and copy down for 9 more cells
--
HTH
RP
(remove nothere from the email address if mailing direct)
J
Jeroen
Hi there,
There is not a function that does the trick but if you can set up a pivot
table, the solution on the following link may help you out:
http://techonthenet.com/excel/pivottbls/top10.php
There is not a function that does the trick but if you can set up a pivot
table, the solution on the following link may help you out:
http://techonthenet.com/excel/pivottbls/top10.php
D
DClark5412
Many thanks for all your replies - they have all been useful, clearly put and
given me options.
given me options.