I need function that can list the "top ten" highest results

[DClark5412]

Can anyone help me find a function in excel that will find the top ten
highest scores in my data?

[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



"DClark5412" <[email protected]> wrote in message
news:[email protected]...
> Can anyone help me find a function in excel that will find the top ten
> highest scores in my data?

[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)


"DClark5412" <[email protected]> wrote in message
news:[email protected]...
> Can anyone help me find a function in excel that will find the top ten
> highest scores in my data?

[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

--
Jeroen van Nieuwkerk




"DClark5412" wrote:

> Can anyone help me find a function in excel that will find the top ten
> highest scores in my data?

[DClark5412]

Many thanks for all your replies - they have all been useful, clearly put and
given me options.