How to find 2nd or 3rd or even 4th maximum value in a range (One column range) (Non VBA solution) (Excel 2003)
Thanks
Best Regards
How to find 2nd or 3rd or even 4th maximum value in a range (One column range) (Non VBA solution) (Excel 2003)
Thanks
Best Regards
Last edited by mahju; 05-24-2011 at 10:43 PM.
Mark the thread as solved if you are satisfied with the answer.
In your first post under the thread tools.
Mahju
Try this for the 2nd max value. Change the 2 to correspond to the max value you would like.
Does this work for you?
=LARGE(A1:A10,2)
Thanks
That works nicely
Regards
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks