View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
The Greek The Greek is offline
external usenet poster
 
Posts: 14
Default 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