Hi all,
I hope you can help.
Please could anyone find the formula for column E.
Many thanks in advance. Sorry about the formatting
I hope you can help.
Please could anyone find the formula for column E.
Name | Groups | Score | Rank in group | Result in group |
Sam | Group A | 18 | 4 | NOTHING |
Charlie | Group A | 20 | 1 | PLAYOFF |
Billy | Group A | 20 | 1 | PLAYOFF |
George | Group A | 20 | 1 | PLAYOFF |
Lindsey | Group F | 16 | 2 | PLAYOFF |
Lee | Group F | 18 | 1 | TROPHY |
Tom | Group F | 16 | 2 | PLAYOFF |
Stevie | Group Z | 13 | 3 | TROPHY |
Lucy | Group Z | 15 | 2 | TROPHY |
Megan | Group Z | 19 | 1 | TROPHY |
Groups | Trophy's in Grp | |||
Group A | 1 | |||
Group F | 2 | |||
Group Z | 3 | |||
Criteria | ||||
Depending on the number of Trophies, Highest scores receive a TROPHY | ||||
if there are trophies, but 2 or more score the same PLAYOFF | ||||
People with the lowest score and there is no Trophy's GET NOTHING |
Many thanks in advance. Sorry about the formatting