create option style table

hello all
can some one help me create option style seeding table, i.e. i have 8 pairs (1/8 finals) from row 6 down to row 23 and winner goes to next round. In column I i want option that if i select Y for rider A then rider B should be N or vice versa. and then the winner name should automatically get updated in column N. attaching the file for reference.

regards

I think this is the easiest way since this spreadsheet is pretty small, is to just hand enter the formulas with this basic format:

Please Login or Register  to view this content.