Not sure if I understand what you want, but try this...
I created a table off to the side like this...
AH AI 2 10647 1 3 36047 2 4 35969 3 5 54681 4 6 34829 5 7 22588 6 8 64175 7 9 91013 8 10 87483 9 11 30058 10
AH2=RAND()*100000
I only copied down to 10, but it goes down to 20
Then in A10, copied down...
=VLOOKUP(LARGE($AH$2:$AH$21,MOD(ROW(A1),13)+MOD(ROW(A1),13)*1-2+1),$AH$2:$AI$21,2,0)
Then copy this to C10, and copy down...
=VLOOKUP(LARGE($AH$2:$AH$21,MOD(ROW(A1),13)+MOD(ROW(A1),13)*1-2+1),$AH$2:$AI$21,2,0)
Once you have the 1st 2 sets of columns done, you can copy that "set" to all weeks
Bookmarks