Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup top 5 values (MAX function?)
I'm hoping to populate a table showing the top 5 values in a list of
20,000+ currency values. Without having to sort, is there any way of looking up the MAX -1, MAX-2, etc.?? Any help will be greatly appreciated. Thanks, Donnie |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup top 5 values (MAX function?)
=large(A1:A1000,ROW(A1))
and copy down as many as you want -- HTH Bob Phillips (remove nothere from email address if mailing direct) wrote in message oups.com... I'm hoping to populate a table showing the top 5 values in a list of 20,000+ currency values. Without having to sort, is there any way of looking up the MAX -1, MAX-2, etc.?? Any help will be greatly appreciated. Thanks, Donnie |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Lookup top 5 values (MAX function?)
Or maybe
=large($A$1:$A$1000,row(A1)) -- Regards, Peo Sjoblom "Bob Phillips" wrote in message ... =large(A1:A1000,ROW(A1)) and copy down as many as you want -- HTH Bob Phillips (remove nothere from email address if mailing direct) wrote in message oups.com... I'm hoping to populate a table showing the top 5 values in a list of 20,000+ currency values. Without having to sort, is there any way of looking up the MAX -1, MAX-2, etc.?? Any help will be greatly appreciated. Thanks, Donnie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need Help with lookup values in Table | Excel Discussion (Misc queries) | |||
How can I use the vlookup function to return a sum of the values? | Excel Discussion (Misc queries) | |||
lookup function 1 | Excel Worksheet Functions | |||
Lookup function skipping columns | Excel Worksheet Functions | |||
Lookup Function Problem | Excel Discussion (Misc queries) |