Can I Scramble Data

R

randy

Does anyone know how to scramble/mix up data easily?

I have an excel Spreadsheet that have a range of columns
and rows of items - biweekly I need to have the same
items in the spreadsheet just in another cell.

I thought about sorting - but that doesn't work randomly.

Any Ideas?
 
J

JulieD

Hi Randy

you could use the =RAND() function in an adjacent to generate random numbers
and then sort on these (after edit / paste special - values).

Cheers
JulieD
 
Top