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?
|