View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default Getting top 5 values in a list of numbers

=LARGE(TheList,k)

k being any value from 1 to 5 for your purposes.

--

Vasant



"Roel" wrote in message
...
Hi,

I would like to know if there is a way to get the 5 largest values in

a
list of numbers. I know using MAX would only get the largest. I would like
some rountine that would do it.


Thanks very much!

Roel