| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Validating random numbers
I need to generate a list of 10 random numbers, between 3 and 78. These
represent identification numbers of stores. However, some of those numbers are not valid (i.e., 13, 15, 20-49,55-57). I used "randbetween" to get the numbers between 3 and 78. I've tried various combinations of "IF" and "AND" to screen out the numbers I don't want. Anybody have a way to do this? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Generate random numbers 1-100 without any repeats? | Excel Worksheet Functions | |||
| Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
| How do I split a column having numbers and text in a random order | Excel Worksheet Functions | |||
| Random Numbers Change? | Excel Worksheet Functions | |||
| generate random numbers | Excel Worksheet Functions | |||
Threaded Mode
