Hello GillesD

I saw a formula for excel that you wrote for someone, creating random numbers. Sorry I did not take note of the thread and I tried searching this forum. I have setup this random number with the following criteria;

This is based on a pool of 40 numbers reference A1 to F1 for the 6 generated numbers.

A1 is =randbetween(1,35) B1 is =randbetween(A1+1,36) etc

I would also like to add certain criteria to the above but still remain random. Unfortunately I am no good at macros;

I want to be able to add the following;

Sum range ie: min 90 max 150 - user adjustable.

Odd: min 2 max 4 - user adjustable.

Low: min 2 max 4 - user adjustable.

So when you press "F9" it creates a random number checks the criteria above and if okay displays it otherwise creates another random number.

I'll have a shot at creating a macro tonight with the "user adjustable" accessable from the spread sheet itself rather than going into the macro all the time.

I can think of a lot more criteria...too many to mention.

Thank you in advance,

Irvin.

PS. You never know, for random picks, this might prove better that Quick Pick, Random Pick, Auto Pick, Lucky Dip...in NZ or whatever you like to call it Since it is still random but with the criteria you set.

I saw a formula for excel that you wrote for someone, creating random numbers. Sorry I did not take note of the thread and I tried searching this forum. I have setup this random number with the following criteria;

This is based on a pool of 40 numbers reference A1 to F1 for the 6 generated numbers.

A1 is =randbetween(1,35) B1 is =randbetween(A1+1,36) etc

I would also like to add certain criteria to the above but still remain random. Unfortunately I am no good at macros;

I want to be able to add the following;

Sum range ie: min 90 max 150 - user adjustable.

Odd: min 2 max 4 - user adjustable.

Low: min 2 max 4 - user adjustable.

So when you press "F9" it creates a random number checks the criteria above and if okay displays it otherwise creates another random number.

I'll have a shot at creating a macro tonight with the "user adjustable" accessable from the spread sheet itself rather than going into the macro all the time.

I can think of a lot more criteria...too many to mention.

Thank you in advance,

Irvin.

PS. You never know, for random picks, this might prove better that Quick Pick, Random Pick, Auto Pick, Lucky Dip...in NZ or whatever you like to call it Since it is still random but with the criteria you set.

Last edited: Jul 18, 2003