Picking second high from a list

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

The Greek - 17 Mar 2008 16:00 GMT

I have a list like the following:

A = 8
B = 8
C = 6
D = 5
E = 5
F = 3
G = 2

I am using the VLOOKUP and LARGE formula in order to pick the highest
three. I can properly pick the first and the third but not the second
because the first and the second are equa.

How can I do it??

Thank

Reply to this Message

Ron Coderre - 17 Mar 2008 16:19 GMT

With your posted data in A1:G1

Try this:
This ARRAY FORMULA (committed with CTRL+SHIFT+ENTER, instead of ENTER)
returns the 2nd highest ranked item (ignoring duplicates):

H1:=LARGE(IF(MATCH(A1:G1,A1:G1,0)=COLUMN(A1:G1),A1:G1),2)

Is that something you can work with?
Post back if you have more questions.
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

>I have a list like the following:
>
[quoted text clipped - 13 lines]
>
> Thank

Reply to this Message