Random sorting

Tonester101 · Mar 30th, 2004, 07:23 PM

Hi all

I have tried searches hear for my following problem but with no joy.

I am creating a competition for Euro 2004 (a major european soccer tournament for those that don't know). There are 4 groups with 4 teams in each group. Each player will get 1 team from each group. I have typed out all the combinations (all 256 of them!!). Down a column I have wrote numbers 1 to 256. Can I sort the column of numbers into a random order? These will then link to all combinations. I have absolutely no knowledge of VB and need someones help so I don't have to go to a random cell in the column and type each number. I hope this makes sense.

Thanks to anyone that can help

Cheers

Tonester

DRJ · Mar 30th, 2004, 07:42 PM

Instead of typing 1-256 put this in the first cell

=rand()

Fill down for all the rows

Now sort my that column

After sorting re-number 1-256

kkknie · Mar 30th, 2004, 07:43 PM

Change the numbers 1-256 to =RAND(). Hit F9 a couple of times then select all the column and choose Copy then Paste Special and select Values. Then sort on the column with the random numbers.

K

Edit: Dang Jacob is fast...

Tonester101 · Mar 30th, 2004, 08:42 PM

Thank you both. I tried the first and it worked but offer many thanks to both replies. It has saved so much time.

Cheers

Tonester

DRJ · Mar 31st, 2004, 02:32 AM

Glad to help

Take Care

Mar 30th, 2004, 07:23 PM	#1
Tonester101 Join Date: Nov 2003 Location: Birmingham, England Posts: 6	Random sorting Hi all I have tried searches hear for my following problem but with no joy. I am creating a competition for Euro 2004 (a major european soccer tournament for those that don't know). There are 4 groups with 4 teams in each group. Each player will get 1 team from each group. I have typed out all the combinations (all 256 of them!!). Down a column I have wrote numbers 1 to 256. Can I sort the column of numbers into a random order? These will then link to all combinations. I have absolutely no knowledge of VB and need someones help so I don't have to go to a random cell in the column and type each number. I hope this makes sense. Thanks to anyone that can help Cheers Tonester

Mar 30th, 2004, 07:42 PM	#2
DRJ MrExcel MVP Join Date: Feb 2002 Location: California Posts: 3,857	Instead of typing 1-256 put this in the first cell =rand() Fill down for all the rows Now sort my that column After sorting re-number 1-256 __________________ Excel VBA Training and Certification (Lesson 1 is free) <hr> <hr>-Jacob

Mar 30th, 2004, 07:43 PM	#3
kkknie Join Date: Apr 2002 Location: Greenwood, SC Posts: 677	Re: Random sorting Change the numbers 1-256 to =RAND(). Hit F9 a couple of times then select all the column and choose Copy then Paste Special and select Values. Then sort on the column with the random numbers. K Edit: Dang Jacob is fast...

Mar 30th, 2004, 08:42 PM	#4
Tonester101 Join Date: Nov 2003 Location: Birmingham, England Posts: 6	Re: Random sorting Thank you both. I tried the first and it worked but offer many thanks to both replies. It has saved so much time. Cheers Tonester

Mar 31st, 2004, 02:32 AM	#5
DRJ MrExcel MVP Join Date: Feb 2002 Location: California Posts: 3,857	Glad to help Take Care __________________ Excel VBA Training and Certification (Lesson 1 is free) <hr> <hr>-Jacob

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode