How do I jumble data in Excel 2003?
 

I am using Excel 2003 and want to Jumble the data for audit which we get in a
sorted manner.

How do I jumble data in Excel 2003?
 

There is a random value function =RAND(). Put this in the first cell of a
spare column and copy down. Then you can sort the data on this column. Note
that you will get new random values every time the spreadsheet
recalculates - whenever you edit or do anything. If you want to keep one set
of random values, copy the column and Paste Values over the =RAND()
formulas.

"Naveen Khattar" <Naveen wrote in message
...
I am using Excel 2003 and want to Jumble the data for audit which we get in
a
sorted manner.

How do I jumble data in Excel 2003?
 

If, for example, your data is in column A, then in B1 enter:

=RAND() and copy down

Sort both columns A & B by B. This will jumble or randomize the cells in
column A. You can then pick a subset.
--
Gary''s Student - gsnu200761


"Naveen Khattar" wrote:

I am using Excel 2003 and want to Jumble the data for audit which we get in a
sorted manner.

How do I jumble data in Excel 2003?
 

Hi,

You could use a helper column alongside your data and enter the formula
=Rand()
Drag the formula down to the last row of your data
Select your data and this new column and sort by the new column.

Mike

"Naveen Khattar" wrote:

I am using Excel 2003 and want to Jumble the data for audit which we get in a
sorted manner.