Copy the number to column G. then put =RAND() in cell H1 and copy down column
H to the end of column G. Then sort columns G & H using column H as the sort
key. Column g will then be randomized.


"Six Sigma Blackbelt" wrote:

Basically i have set of numbers that are numerical, 1 to what ever is
generated for that column (a19 is where they start), i need to take the
number from that column (a19) and move them to another column (g19) but
randomize them at the same time. So when the numerical numbers in a19 are
completed, i need them to move to g19 but be randomize.

Sounds complicated

MJS