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

[Guest]

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?

 

[Guest]

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

 

[Nick Hodge]

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
(e-mail address removed)

 

[Guest]

Thank you very much!

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
(e-mail address removed)

 

[Guest]

Thank You! Appreciate the help!

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