Picking second high from a list

[The Greek]

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

 

[Ron Coderre]

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)