C
Charles
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?
top 5 numbers how do you do this?
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.
I have a set of numbers in an excel spreadsheet and want to find t
P
Peo Sjoblom
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
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
N
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
[email protected]
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
[email protected]
C
Charles
Thank you very much!
Nick Hodge said: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
[email protected]
C
Charles
Thank You! Appreciate the help!
Peo Sjoblom said: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