Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Randomization of groupings based on value
Hi all, Looking for a way to randomly reorder a column of data on an excel spreadsheet. Essentially I have a list of ordered ID numbers in the 1st col, a list of weights in the 2nd col. I want to randomize based on the first column, resizing the sort to include the 2nd. I tried fooling with some code I ripped from a vba card game but it's a hopeless mess at this point. Any help would be greatly appriciated. -- Ouka ------------------------------------------------------------------------ Ouka's Profile: http://www.excelforum.com/member.php...o&userid=23988 View this thread: http://www.excelforum.com/showthread...hreadid=498135 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Randomization of groupings based on value
Ouka,
Use an adjacent blank column or insert one next to your two columns. Then enter random numbers in that column and run a sort on all three columns using the random column as the key1 sort column. Jim Cone San Francisco, USA http://www.realezsites.com/bus/primitivesoftware "Ouka" wrote in message ... Hi all, Looking for a way to randomly reorder a column of data on an excel spreadsheet. Essentially I have a list of ordered ID numbers in the 1st col, a list of weights in the 2nd col. I want to randomize based on the first column, resizing the sort to include the 2nd. I tried fooling with some code I ripped from a vba card game but it's a hopeless mess at this point. Any help would be greatly appriciated. -- Ouka |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Tables with different groupings based on same data table | Excel Discussion (Misc queries) | |||
Pivot Tables with different groupings based on same data table | New Users to Excel | |||
Excel - randomization with certain criteria | Excel Worksheet Functions | |||
Data Randomization | Excel Worksheet Functions | |||
strange randomization | Excel Programming |