Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Radomising rows in a spreadsheet
I currently have a list of data that looks like this:
Pay No Name Age 1 Dave 23 2 James 35 3 Lucy 19 etc And I need some code that can randomise the order of the rows so that the outcome will look like this: Pay No Name Age 19 Joanne 29 31 Susan 44 1 Dave 23 etc Can anyone help? cdb |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Radomising rows in a spreadsheet
in the column beyond age, put in
=rand() in the top cell (D2 for example) and copy down. then sort the data using that column as the key value. -- Regards, Tom Ogilvy "cdb" wrote in message ... I currently have a list of data that looks like this: Pay No Name Age 1 Dave 23 2 James 35 3 Lucy 19 etc And I need some code that can randomise the order of the rows so that the outcome will look like this: Pay No Name Age 19 Joanne 29 31 Susan 44 1 Dave 23 etc Can anyone help? cdb |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I add many rows in between existing rows in spreadsheet? | Excel Worksheet Functions | |||
Linked Spreadsheet rows | Excel Worksheet Functions | |||
Adding five new rows every 40 rows in a spreadsheet? | Excel Discussion (Misc queries) | |||
How to add only certain rows in a spreadsheet | Excel Worksheet Functions | |||
Search Rows in a spreadsheet | Excel Programming |