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:
=LARGE(A1:A1000,3)
For Minimum - (you guessed it) try SMALL formula
'should give the 2nd smallest numberFormula:=SMALL(A1:A1000,2)
HTH!
Hi
instead thisFormula:=LARGE(A1:A1000,3)
Use thisCopy down.Formula:=LARGE(A1:A1000,ROWS($1:1)
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