I have a set of numbers in an excel spreadsheet and want to find t
 

I have a set of numbers in a column in an excel spreadsheet and want to find
top 5 numbers how do you do this?

Sort them descending and select the five first
Use autofilter and select top 10 and in the next window select 5 and click OK
Use a formula like this and copy down 5 rows

=LARGE($A$1:$A$100,ROW(1:1))


Regards,

Peo Sjoblom

"Charles" wrote:

I have a set of numbers in a column in an excel spreadsheet and want to find
top 5 numbers how do you do this?

Charles

Use the LARGE function. If the data is in the range A2:A50 then use the
formula

=LARGE($A$2:$A$50,1)

then copy it down 5 rows and change the 1 to 2, etc.

If you want the answers in B2:B6 then you could elaborate with the
following, entered in B2 and copied down

=LARGE($A$1:$A$32,ROW(2:6)-1)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Charles" wrote in message
...
I have a set of numbers in a column in an excel spreadsheet and want to
find
top 5 numbers how do you do this?

Thank you very much!

"Nick Hodge" wrote:

Charles

Use the LARGE function. If the data is in the range A2:A50 then use the
formula

=LARGE($A$2:$A$50,1)

then copy it down 5 rows and change the 1 to 2, etc.

If you want the answers in B2:B6 then you could elaborate with the
following, entered in B2 and copied down

=LARGE($A$1:$A$32,ROW(2:6)-1)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Charles" wrote in message
...
I have a set of numbers in a column in an excel spreadsheet and want to
find
top 5 numbers how do you do this?

Thank You! Appreciate the help!

"Peo Sjoblom" wrote:

Sort them descending and select the five first
Use autofilter and select top 10 and in the next window select 5 and click OK
Use a formula like this and copy down 5 rows

=LARGE($A$1:$A$100,ROW(1:1))


Regards,

Peo Sjoblom

"Charles" wrote:

I have a set of numbers in a column in an excel spreadsheet and want to find
top 5 numbers how do you do this?