Randomizing Exisiting Data Sets 1

[Mut]

I have 78 rows of seperate data sets. I need to randomize those 78 rows without writing a macro. Is there a way to do this?

 

[jjonesal]

Is this in Access, Excel, what? I'm not sure I fully understand the question, so If I'm way off base, just disregard.

If it's in Access, I think you could create a query and include a calculated field in your query that is a random number (using the RND function). Then, sort based on the new calculated random number field.

If in Excel, again you could include a column (even hide it if you didn't want anyone to see it) that uses the RAND() function to generate a random number. Then, sort the records based on that column.

Just a thought... J. Jones
jjones@cybrtyme.com

 

[Mut]

D'oh. Sorry. It's in excel. I have existing numbers, so I don't have to create new numbers - I have to randomize existing ones. For ex, i have:

14.2
28.45
18.1
17.2

etc.

I want these number to be randomized - not create new random numbers.

 

[jjonesal]

Maybe I'm not communicating clearly, but what I'm saying is create a new random number JUST for the purpose of sorting the records. You wouldn't even show it at all (you'd show your original numbers). The only purpose for this new random number would be to randomize the records (by sorting).

Hope this makes sense... J. Jones
jjones@cybrtyme.com