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
