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.
|