I have 4 lists of store numbers, each list representing the size of the
respective stores, I need to select 4 random numbers from each list of
numbers.
Each number is unique to a store and starts from 2000 up to at present 6500.
Once this store number has been generated I need it to be static so that I
can use it with lookup functions to select specific data from each store
identified. Each list starts at cell FI10:FI3000, FJ10:FJ3000, FK10:FK3000 &
FL10:FL3000 resepectively. All the numbers have been listed sequentially but
there are blank cells between the number.
Can anyone assist me with this.
Many thanks in anticipation.

Regards Lee

Start with a RANDBETWEEN(2000,6500) in your 4 columns.

Once you hit enter, highlight the 4 values, copy, paste special - values to
freeze them.

"leerem" wrote:

I have 4 lists of store numbers, each list representing the size of the
respective stores, I need to select 4 random numbers from each list of
numbers.
Each number is unique to a store and starts from 2000 up to at present 6500.
Once this store number has been generated I need it to be static so that I
can use it with lookup functions to select specific data from each store
identified. Each list starts at cell FI10:FI3000, FJ10:FJ3000, FK10:FK3000 &
FL10:FL3000 resepectively. All the numbers have been listed sequentially but
there are blank cells between the number.
Can anyone assist me with this.
Many thanks in anticipation.

Regards Lee

Sean, this wont work because lets say No. 2001 will be in list 1, 2002 will
be in list 3, 2004 in list 2 & 2005 in list 1 etc. selecting a random number
between 2000,6500 will include no's that may not be in the list.

"Sean Timmons" wrote:

Start with a RANDBETWEEN(2000,6500) in your 4 columns.

Once you hit enter, highlight the 4 values, copy, paste special - values to
freeze them.

"leerem" wrote:

I have 4 lists of store numbers, each list representing the size of the
respective stores, I need to select 4 random numbers from each list of
numbers.
Each number is unique to a store and starts from 2000 up to at present 6500.
Once this store number has been generated I need it to be static so that I
can use it with lookup functions to select specific data from each store
identified. Each list starts at cell FI10:FI3000, FJ10:FJ3000, FK10:FK3000 &
FL10:FL3000 resepectively. All the numbers have been listed sequentially but
there are blank cells between the number.
Can anyone assist me with this.
Many thanks in anticipation.

Regards Lee

Two options I can think of:

1) Continue to hit enter on the random number til it matches one of the
above, or

2) create some VB code.

Use the random generator below and loop with a find...

"leerem" wrote:

Sean, this wont work because lets say No. 2001 will be in list 1, 2002 will
be in list 3, 2004 in list 2 & 2005 in list 1 etc. selecting a random number
between 2000,6500 will include no's that may not be in the list.

"Sean Timmons" wrote:

Start with a RANDBETWEEN(2000,6500) in your 4 columns.

Once you hit enter, highlight the 4 values, copy, paste special - values to
freeze them.

"leerem" wrote:

I have 4 lists of store numbers, each list representing the size of the
respective stores, I need to select 4 random numbers from each list of
numbers.
Each number is unique to a store and starts from 2000 up to at present 6500.
Once this store number has been generated I need it to be static so that I
can use it with lookup functions to select specific data from each store
identified. Each list starts at cell FI10:FI3000, FJ10:FJ3000, FK10:FK3000 &
FL10:FL3000 resepectively. All the numbers have been listed sequentially but
there are blank cells between the number.
Can anyone assist me with this.
Many thanks in anticipation.

Regards Lee