View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default 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