So close to getting it... first i have list of teams B3 - B83 and random number being created next to each A3-A83. =rand()

starting in P3. =LARGE(A$3:A$82,ROW(A1:A82)) and Q3 =VLOOKUP(P3,$A$3:$B$82,2,FALSE). this gives me an order from large number to small random from there i pair the teams. Great cause i have the pairings for the first week.

On sheet 2 I take those pairs from week 1 and run pairings again using conditional formatting it shows any dups from week 1. So i would just use f9 to change til there are no dups. The problem happens when doing this over 25 weeks with no dups its almost imposible to not getting dup pairings.

Is there a way to have pairings generated without dups from the previous weeks? Going about this the wrong way?