Excel Help: How to have a Competition Leader

B

BigmanMarch

Joined
Jun 10, 2012
Messages
1
Reaction score
0
I've made a spreadsheet to log a Euro match prediction game I am running with three workmates.

I have input all of the details and if a score is predicted correctly the predictor gets 3 points, if they get the result right they get 1 point.

I have put a cell at the bottom of each score column that works out the total points each predictor has.

At the bottom I want to put a 'Leader' cell that names the current winner after each match.

The total score for each person are in cells C26, E26, G26 and I26, I want to do a cell that effectively shows this:

=IF(C26<E26,G26,I26, "Frank"), (IF(E26<C26,G26,I26, "Chris")), (IF(G26<C26,E26,I26, "Ryan")), (IF(I26<C26,G26,E26, "Ross"))

So I want the name of the current winner to be shown when they have the most points after inputting details.

But this equation does not work. Can someone help me?

Thank you,
 
Last edited:
Alright, I think I have something, assuming you have the names of the people in Row 1 of the data array:
=INDIRECT("R1C"&MATCH(MAX(C26,E26,G26,I26),A26:I26,0),False)

The problem with your formula is that Excel doesn't look at commas at OR statements. If you wanted to do it with IF statements, you could do the following, but it would be much longer:
=IF(AND(C26>E26,C26>G26,C26>I26),"Frank",IF(AND(E26>C26,E26>G26,E26>I26),"Chris",IF(AND(G26>C26,G26>E26,G26>I26),"Ryan",IF(AND(I26>C26,I26>E26,I26>G26),"Ross"))))

Of cours after typing all that, you could replace those and formulas with MAX(C26,E26,G26,I26)=C26 and so on for each person. Let me know what works for you. Good Luck!
 
Back
Top