Randomization of groupings based on value

  • Thread starter Thread starter Ouka
  • Start date Start date
O

Ouka

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,

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" <[email protected]>
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Random selection of records based on specifc value 5
Six columns randon no.'s no dupes 6
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Weighted randbetween text list 3
Weighted Random Selection 5
Random Range of Dates 2
Total columns Based on another cells value 4
Format sheet based on column contents 1

Back
Top