Pick 4 numbers between 1 and 22.

[brendy]

Doesn my hair really look like that?

 

[brendy]

Come on chaps, only need another two sets of three, whos next?

 

[john0]

9 13 17

Can i come back in now?

 

[bobmac]

Come on chaps, only need another two sets of three, whos next?

Not on your Nelly.
I'm not going to fall for it again. Not I. No sirree. Nope. Nothing from yours truely. Do your own dirty work, I'm tired out.
In the words of Mr. theodopopolis...I'm out


9, 11, 17

 

[brendy]

Yes John, all sorted, thankyou very much fella.

 

[bobmac]

Well, who am I playing with?

 

[john0]

Well, who am I playing with?

Yourself as usual

 

[brendy]

Bob, you were more than welcome to come over, one other pro playing too
Groupings done and will be posted in the GM Irish Craic Classic thread.
Thanks again fellas.

 

[Tiger]

Guys if you ever need to create a random sample and have excel do this

Leave column A blank
Have the data you wish to randomise in rows starting in column B
Select cell A1 Type =RAND() in the formula text box
Then drag that down the column to copy into cells that correspond to your other data (in Brendy's case 1-22)
Now sort by column A largest to smallest

Job done

 

[Region3]

Before you sort by col A though you need to Copy > Paste Values, as the random numbers change every time the worksheet alters.

 

[john0]

Guys if you ever need to create a random sample and have excel do this

Leave column A blank
Have the data you wish to randomise in rows starting in column B
Select cell A1 Type =RAND() in the formula text box
Then drag that down the column to copy into cells that correspond to your other data (in Brendy's case 1-22)
Now sort by column A largest to smallest

Job done

Before you sort by col A though you need to Copy > Paste Values, as the random numbers change every time the worksheet alters.

Choo Choo..........what time is the next train along fellas?

 

[richart]

Guys if you ever need to create a random sample and have excel do this

Leave column A blank
Have the data you wish to randomise in rows starting in column B
Select cell A1 Type =RAND() in the formula text box
Then drag that down the column to copy into cells that correspond to your other data (in Brendy's case 1-22)
Now sort by column A largest to smallest

Job done

Before you sort by col A though you need to Copy > Paste Values, as the random numbers change every time the worksheet alters.

Choo Choo..........what time is the next train along fellas?

Brendy's way is much more fun. Thinking of doing something similar for Blackmoor Meet. Just one number needed beween 1 and 46 to find out who has to play with Smiffy.

 

[john0]

And what number are you richart?

 

[richart]

47 !

 

[brendy]

Excel is no fun, honest, I get to use it all day and still dont know half of it!

Asking the bums on here who have nothing better to do is more exciting!

 

[Tiger]

Guys if you ever need to create a random sample and have excel do this

Leave column A blank
Have the data you wish to randomise in rows starting in column B
Select cell A1 Type =RAND() in the formula text box
Then drag that down the column to copy into cells that correspond to your other data (in Brendy's case 1-22)
Now sort by column A largest to smallest

Job done

Before you sort by col A though you need to Copy > Paste Values, as the random numbers change every time the worksheet alters.

Choo Choo..........what time is the next train along fellas?

Gary well spotted

John Freight or Passenger?

 

[Smiffy]

I feel cheap and used...like one of Smiffy's wetwipes

Are you on drugs?