Determining placings based on total scores (1st, 2nd...10th) (determined by the

Question

Determining placings based on total scores (1st, 2nd...10th) (determined by the tally at the end of event) and listing them and their corresponding points from highest to lowest!

In F4:X4 are the following text cells

In F31:X31 will be a total for each of the above, which is undetermined until the end of the event. The highest total will be 1st place, second highest will be 2nd place....10th place with the lowest total.

In A33:C43 is a table as follows:

I want first place (the one with the highest score at the end of the event) to appear in B34 and their respective points to appear in C34; 2nd place to appear in B35 and the corresponding points to appear in C35...

I've had IF, LOOKUP, INDEX and MATCH formula's going through my head, but I really don't know how to go about the solution of this! Help!!!

Explanation / Answer

Hi..

Hi,

Put this in B34 and drag down.

=INDEX($F$4:$X$4,MATCH(LARGE($F$31:$X$31,ROW(A1)),$F$31:$X$31,0)).

EDIT...I just realised you may have ties and if that's possible then use this ARRAY formula in B34. ARRAY enter it, see below, and then drag down.

=INDEX($F$4:$X$4,MATCH(LARGE($F$31:$X$31+(COLUMN($F$31:$X$31)/10000),ROW(A1)),$F$31:$X$31+(COLUMN(F31:X31)/10000),0))

This is an array formula which must be entered by pressing CTRL+Shift+Enter
and not just Enter. If you do it correctly then Excel will put curly brackets
around the formula {}. You can't type these yourself. If you edit the formula
you must enter it again with CTRL+Shift+Enter..

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.