Spreadsheet: 82764d1282781170-competition-template-if-statement-problems-demo
Sheet: Entries

 | Event 1 |  |  |  |  |  |  | Event 2 |  |  |  |  | Event 3 |  |  |  |  | Event 4 |  |  |  |  | Event 5 |  |  |  |  | Event 6 |  |  |  |  | Event 7 |  |  |  |  | Event 8 |  |  |  |  | Event 9 |  |  |  |  | Event 10 |  |  |  |  | Event 11 |  |  |  |  | Event 12 |  |  |  |  | Event 13 |  |  |  |  | Event 14 |  |  |  |  | Event 15 |  |  |  |  | Event 16 |  |  |  |  | Event 17 |  |  |  |  | Event 18 |  |  |  |  | Event 19 |  |  |  |  | Event 20
 | [NAME] |  |  |  |  |  |  | Ladies Singles |  |  |  |  | [NAME] |  |  |  |  | Ladies Doubles |  |  |  |  | [NAME] |  |  |  |  | Vets Singles |  |  |  |  | Handicap Singles |  |  |  |  | Restricted Singles |  |  |  |  | Cup Singles |  |  |  |  | Girls Cup Singles |  |  |  |  | Junior boys |  |  |  |  | Junior Girls |  |  |  |  | Junior Doubles |  |  |  |  | [NAME] |  |  |  |  | Cadet girls |  |  |  |  | [NAME] |  |  |  |  | No Event |  |  |  |  | No Event |  |  |  |  | No Event |  |  |  |  | No Event
 | Doubles? | Seeded? |  | Don’t really want a helper colm! |  |  |  | Doubles? | Seeded? |  |  |  | Doubles? | Seeded? |  |  |  | Doubles? | Seeded? |  |  |  | Doubles? | Seeded? |  |  |  | Doubles? | Seeded? |  |  |  | Doubles? | Seeded? |  |  |  | Doubles? | Seeded? |  |  |  | Doubles? | Seeded? |  |  |  | Doubles? | Seeded? |  |  |  | Doubles? | Seeded? |  |  |  | Doubles? | Seeded? |  |  |  | Doubles? | Seeded? |  |  |  | Doubles? | Seeded? |  |  |  | Doubles? | Seeded? |  |  |  | Doubles? | Seeded? |  |  |  | Doubles? | Seeded? |  |  |  | Doubles? | Seeded? |  |  |  | Doubles? | Seeded? |  |  |  | Doubles? | Seeded?
 | Yes | Yes |  |  |  |  |  | N/A | N/A |  |  |  | N/A | N/A |  |  |  | N/A | N/A |  |  |  | N/A | N/A |  |  |  | N/A | N/A |  |  |  | N/A | N/A |  |  |  | N/A | N/A |  |  |  | N/A | N/A |  |  |  | N/A | N/A |  |  |  | N/A | N/A |  |  |  | N/A | N/A |  |  |  | N/A | N/A |  |  |  | N/A | N/A |  |  |  | N/A | N/A |  |  |  | N/A | N/A |  |  |  | N/A | N/A |  |  |  | N/A | N/A |  |  |  | N/A | N/A |  |  |  | N/A | N/A
Players | Entered? | £ | Partner |  | Seeding | Combined | Sorted | Entered? | £ | Partner | Seeding | Combined | Entered? | £ | Partner | Seeding | Combined | Entered? | £ | Partner | Seeding | Combined | Entered? | £ | Partner | Seeding | Combined | Entered? | £ | Partner | Seeding | Combined | Entered? | £ | Partner | Seeding | Combined | Entered? | £ | Partner | Seeding | Combined | Entered? | £ | Partner | Seeding | Combined | Entered? | £ | Partner | Seeding | Combined | Entered? | £ | Partner | Seeding | Combined | Entered? | £ | Partner | Seeding | Combined | Entered? | £ | Partner | Seeding | Combined | Entered? | £ | Partner | Seeding | Combined | Entered? | £ | Partner | Seeding | Combined | Entered? | £ | Partner | Seeding | Combined | Entered? | £ | Partner | Seeding | Combined | Entered? | £ | Partner | Seeding | Combined | Entered? | £ | Partner | Seeding | Combined | Entered? | £ | Partner | Seeding | Combined
fred | a |  | [NAME] | [NAME] | 1 | (1) Fred / Mike | [NAME]
[NAME] | a |  |  | [NAME] | 2 | (2) [NAME] | Seed 2 | SHOULD BE ERROR AS ONLY 1 PLAYER HERE!!
 |  |  |  | 0 |  |  | etc | Maybe state "Player Required"
 |  |  |  | 0 |  |  | etc | But / is missing!!!
 |  |  |  | 0 |  |  | aphabetical
 |  |  |  | 0 |  |  | a-z
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0