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

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

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