Top 3?

[shadow12345]

I am using this formula to get the max value... my question is, can i get the top three values instead?

=MAX(Pivots!$C$6:$C$1000)


Regards

 

[shemayisroel]

Try the LARGE function

To get top 3

=LARGE(array,1)

=LARGE(array,2)

=LARGE(array,3)

This will only work if there are no duplicates... You'll need another approach if you have duplicate values/results

 

[shadow12345]

And thats done it.... thanks.

 

[shemayisroel]

And thats done it.... thanks.

Your welcome!