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