stumped due to duplicate/tie matches

  • Thread starter Thread starter mrcsbeau
  • Start date Start date
M

mrcsbeau

i have a spreadsheet i am creating that looks up an inidividuals name i
column b after it sorts through the numeric information in colum
c---then it returns to me elsewhere the persons name with the highes
number, 2nd, and 3rd.

problem is in case of a tie, then it gives me only the first place nam
in both places, or all three if a 3-way tie...you get the idea, i'
like it to go to the next name in the list,

had a really convulted "if" statement that i could never get to wor
properly

here's the three lines i have and any help would be fantastic

=INDEX(B2:B25,MATCH(MAX(C2:C25),C2:C25,0))

=INDEX(B2:B25,MATCH(LARGE(C2:C25,2),C2:C25,0))

=INDEX(B2:B25,MATCH(LARGE(C2:C25,3),C2:C25,0))

again thank you very muc
 
is it possible to reference a nother column altogether and have i
weighted just 1-25 or so and have that as the second reference?
 
Back
Top