Can I Scramble Data

  • Thread starter Thread starter randy
  • Start date Start date
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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting scrambled when combined with sorting in 200 3
sorting problem 3
help with sorting 2
Screen Scrambles 1
modified amortization schedule for open ended loan with EOM LPP ch 7
How to protect data in rows from being seperated during sort 2
I get scrambled data on form. 1
Scrambled data 3

Back
Top