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

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