I am looking for a way to find a highest (and/or) lowest value in a list of numbers. The list keeps getting longer and after a certain point I will need the 2 highest (or lowest), then the 3 highest (or lowest). I know MIN and MAX will find the high and low, but how do I find the 2nd highest, etc?
"Laugh? I thought I'd die!"
Jimbo?
Take a look at LARGE() and SMALL()
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
For Maximum - try LARGE formula
'should give the 3rd largest numberFormula:
Please Login or Register to view this content.
For Minimum - (you guessed it) try SMALL formula
'should give the 2nd smallest numberFormula:Please Login or Register to view this content.
HTH!
Hi
instead thisFormula:Please Login or Register to view this content.
Use thisCopy down.Formula:Please Login or Register to view this content.
Large change to Small copy down
It will give you Highest,2 Highest,3 Highest,4 Highest,5 Highest so on where you want to stop!!
Regard
micope21
Last edited by micope21; 07-25-2014 at 02:22 AM.
To help you by my post? it would be nice to click onto say "Thank you".
If you are happy with a solution to your problem?
Click Thread Tools above your first post,
select "Mark your thread as Solved".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks