I'm trying to find a formula to tell me what the second highest number of a column is. Any help would be greatly appreciated. Thank You so Much.
I'm trying to find a formula to tell me what the second highest number of a column is. Any help would be greatly appreciated. Thank You so Much.
Try
=LARGE(A:A,2)
Change 2 to 3 for 3rd highest etc
Use this if you wish to list them
=LARGE(A:A,ROW(A1))
Change A1 to A2 to start at the 2nd highest
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
If your column contains these numbers, which is the second highest?
7,6,7,8,6,8,
If the answer should be 8 then
=LARGE(A1:A6,2)
If the answer should be 7
=LARGE(A1:A6,COUNTIF(A1:A6,MAX(A1:A6))+1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks