Mix/shuffle cells around

Hi all,

Not very good at explaining things but here goes:

I have three values in 100 cells: A,B & C

Out of the 100 cells, A can be in 60, B 10 cells and C 30 cells..
(Each Row can change, A = 50 B = 20 C = 30 - I HAVE A TOTAL OF 10 ROWS)

Cell A1 = A all the way to A60
Cell A61 = B all the way to A70
Cell A71 = C to 100


I want to mix them up
Example:
A1 = A
A2=A
A3 = C
A4 = A
A5 = B

so on and so on
Can I highlight the cells I want to mix up?


Thanks
Al

Originally Posted by sweep

Hi,

In Column B, enter =RAND(), copied down adjacent to your data.

Then select columns A and B, and sort based on column B.

When I do =rand() it comes up with numbers 0,1 when I drag it across?

so it looks like this (going from L15 to L115)
ACBABBABCCCABB ETC
0001010001000100100 ETC

I would like it to rand mix up:
ACBABBABCCABB (ORIGINAL LINE)
BBACBACACBBAA (MIXUP/SCRAMBLE/SHUFFLE)







aL

Originally Posted by sweep

Your original post suggested you had one column of data (A1:A100) that contained 100 items that needed to be randomised. If this is the case, by placing the formula =RAND() in B1:B100, and then sorting on column B, the data will randomise.

Your latest post suggests that the data is in L15:L115.

If this is the case,

in M15:M115 enter the formula =RAND()
select cells L15:M115

Go to Data > Sort

Choose to sort on Column M, by value

Apologies, tried the above and now works fine... thanks for all your help this is going to save me loads of work!