Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I randomize numbers ALREADY in a column?
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I randomize numbers ALREADY in a column?
If i understand you correctly, you want to randomize the data you have
already put in the sheet. in an empty cell type =rand(), this creates a random number, select copy that number. Next select the data you want to randomize and right click, paste special, and select multiply. Repeat for the other set of data. This multiplies each cell by a random number, not just the same number. -- -John Please rate when your question is answered to help us and others know what is helpful. "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? |
#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? |
Reply |
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 |