Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Randomly alter a column of names
I have a list of place names in column A from row 1 to row 56
Its part of a game so all I want to do is alter the order of names (randomly if possible) There is only one column which is the one with the names in it. thnaks |
#2
|
|||
|
|||
One way ..
Names are assumed in col A, in A1:A20, say Put in C1: =RAND() Put in B1: =INDEX(A:A,MATCH(SMALL(C:C,ROWS($A$1:A1)),C:C,0)) Select B1:C1, copy down to C20 You'd get a random scramble of the names from col A in col B Press F9 to re-generate afresh -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- "Scudo" wrote in message ... I have a list of place names in column A from row 1 to row 56 Its part of a game so all I want to do is alter the order of names (randomly if possible) There is only one column which is the one with the names in it. thnaks |
#3
|
|||
|
|||
For a few different options see
Random Selection http://www.tushar-mehta.com/excel/ne...ion/index.html -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , ional says... I have a list of place names in column A from row 1 to row 56 Its part of a game so all I want to do is alter the order of names (randomly if possible) There is only one column which is the one with the names in it. thnaks |
#4
|
|||
|
|||
.. names in column A from row 1 to row 56
Select B1:C1, copy down to C20 If you have 56 names in A1:A56, just select B1:C1 and copy down to C56 to get the full scramble in col B -- Rgds Max xl 97 --- Singapore, GMT+8 xdemechanik http://savefile.com/projects/236895 -- |
#5
|
|||
|
|||
Thanks for the info......now sorted
"Tushar Mehta" wrote in message m... For a few different options see Random Selection http://www.tushar-mehta.com/excel/ne...ion/index.html -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , ional says... I have a list of place names in column A from row 1 to row 56 Its part of a game so all I want to do is alter the order of names (randomly if possible) There is only one column which is the one with the names in it. thnaks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column Names | Excel Discussion (Misc queries) | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
Counting names in a column but counting duplicate names once | Excel Discussion (Misc queries) | |||
Column A is Town, Column B is names. How can Excel add & tell how. | Charts and Charting in Excel | |||
how can I change the a,b,c, column headers in excel to names | Excel Discussion (Misc queries) |