Picking second high from a list
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
|