Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - Charts - "Data Range" and Date/Time data on X-Axis | Charts and Charting in Excel | |||
Data Import to Excel Issue with Excel 2007 and Excel 2003 on same | Excel Discussion (Misc queries) | |||
Data sort excel 2003 | Excel Worksheet Functions | |||
how to automatically jumble a list of numbers | Excel Discussion (Misc queries) | |||
How do I get data for excel 2003 | New Users to Excel |