Originally Posted by
daddylonglegs
Here's one possible approach.
In E1 put the formula =RAND() and copy this down as far as you need to cover the maximum number of teams you might have, e.g. to E1000.
In D1 enter the number of teams, e.g. 128
In A1 use this formula
=IF(ROW()-ROW(A$1)+1>$D$1/2,"",RANK(OFFSET($E$1,ROW()-ROW(A$1)+(COLUMN()-COLUMN($A1))*($D$1/2),),$E$1:INDEX($E$1:$E$1000,$D$1)))
copy across to B1 and down as far as you might need.
Assuming you have 128 in D1 then A1:B64 will now include one each of numbers 1 to 128. Subsequent cells will be blank. Change D1 to any even number to regenerate numbers. Note: recalculation of worksheet will re-generate random numbers, hide column E if you wish
Bookmarks