fixtures spreadsheet

20 teams, numbered 1 to 20 (duh!)

Each play each other once, over 19 weeks

I need 2 columns per week (or 3 with a 'v' in the middle) showing the fixtures.

I've tried various formulas, but keep getting teams playing twice in a week or repeating each other like 5v6, 6v5 etc.

I tried 1, 2, 3 down col A then 2, 3, 4 down column B but it doesn't work, nor does 20,19,18 down col B.

Struggling!!!

Wonderful.

Looking at it, I'd have never managed the formulae to get their.

Also when I was Googling, I never thought to search for "round-robin".

Thanks a bunch.

You're welcome, glad it worked for you.