| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I randomize numbers ALREADY in a column?
One way
Source numbers assumed in B1:C20 In D1: =RAND() Copy to E1 In F1: =INDEX(B$1:B$20,RANK(D1,D$1:D$20)) Copy to G1. Select D1:G1, copy down to G20. Minimize/hide cols D & E. Cols F & G will return the required random scrambles of cols B & C. Pressing F9 regenerates. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "GrsmRngr" wrote: I have three columns of numbers Column A = 9101-9120, Column B = 9121-9140, and Column C = 9141-9160. I need to randomize columns B & C seperately, but with the numbers that are already in the columns. Can I do this somehow? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Randomize from a list | Excel Discussion (Misc queries) | |||
| randomize data | Excel Discussion (Misc queries) | |||
| Can I randomize whole numbers in my excel sheet? | Excel Worksheet Functions | |||
| How do I randomize words within a row? | Excel Discussion (Misc queries) | |||
| I need to randomize a column of alphanumeric employee ID's for a . | Excel Worksheet Functions | |||
Threaded Mode
