Randomizing Data

[jefflakie]

I have a spreadsheet that has about 3000 total rows of data and that data is similar in about 75 row blocks.

I was wondering how I could randomize the whole 3000 rows.

I was thinking of using a random number beside each row then just sort the data.

I don’t know the formula to insert a random number between x and y

I was also wondering if there is a better way to do this?

[Carim]

Hi,

Something along these lines ...

Please Login or Register  to view this content.

HTH
Carim

[jefflakie]

I tried to paste that in but I dont think it worked.

It says #NAME?

Did I do something wrong?

What would I do to copy and past that down the rows?

[VBA Noob]

Hi,

You need to add the add-in. See attached

http://office.microsoft.com/en-us/ex...092301033.aspx

VBA Noob

[daddylonglegs]

You don't really need RANDBETWEEN

Just use the formula

=RAND()