INDEX / MATCH HELP

  • Thread starter Thread starter challenged
  • Start date Start date
C

challenged

Hi
Maybe I'm going about this the wrong way but am trying to get results from a
competition showing name place and score (top 3 only) onto a seperate
worksheet. There are 4 events for each group. While I can get the results I
want on the same worksheet I would really like a new worksheet so that I can
put in a heap of different results from different groups and print out as one
report.
I'm currently using the following formula.
=INDEX($F$3:$F$14,MATCH(LARGE($E$3:$E$14,ROW(A1)),$E$3:$E$14,0))
Hope you can understand what I'm after.
Any help or advice would be graciously accepted.
Cheers
Jo
 
Hi,
Let' say you have the information in the sheet called sheet1, in the other
sheet enter the formula

=INDEX(sheet1!$F$3:$F$14,MATCH(LARGE(sheet1!$E$3:$E$14,ROW(A1)),sheet1!$E$3:$E$14,0))
 
Back
Top