Random number from a list

L

leerem

I have to generate a random number from a specific list of Numbers, eg:

List 1 List 2 List 3 List 4
2001 2063 2069
2755 3552 2587 2954
3664 3554
3444 5441 4441
3541 4841 3647 the list goes on for some 2000 lines

I cant use Randbetween, because that would produce a number that may not be
in the the specific list. I need to produce 4 numbers at random from each
list, You'll notice that there may be spaces in the table, these spaces
contain an if formula that has been """".

Does anyone know how this can be overcome possibly by using vb code
 
D

Dennis

Can you generate a random number between 1 and the number of numbers in the
list. ?
Why is there more than one list and gaps in the list ?
Can it not be in 1 list or multiple lists without gaps ?

You could then work out which number to pick from your list based on the
random number generated.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Random number selection from 4 lists 3
Making random and unique selections from a list 2
Generate random number from a list 6
Return a random number from a list 4
Random Numbers from a List of Numbers 3
Using "=randbetween" to select a number from a range of cells 4
exclude a number from randbetween function 3
Selecting a random number from a set criteria by clicking a button 1

Top