Thread: MAX FUNCTION
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Souris Souris is offline
external usenet poster
 
Posts: 107
Default MAX FUNCTION

I need retrieve the number of maximun values in my range.

For example the data like following:

20, 90, 40,80,95,100

I need the top 3 numbers are 100,95,90.

The MAX function only return the highest value.

Are there any functions available to retrieve more than one maximum?

Any information is great appreciated,