Chris Davison
MrExcel MVP
- Joined
- Feb 15, 2002
- Messages
- 1,790
Evening all,
how can I return a single random number from the set : 1 to 10 and 20 to 30
ie
8 would be okay
2 would be okay
23 would be okay
29 would be okay
but 15 would not be okay
and 18 would not be okay
Just one random number from those ranges 1-10, 20-30
I'm pretty familiar with =RAND and also have the Analysis Toolpak installed
many thanks
Chris
how can I return a single random number from the set : 1 to 10 and 20 to 30
ie
8 would be okay
2 would be okay
23 would be okay
29 would be okay
but 15 would not be okay
and 18 would not be okay
Just one random number from those ranges 1-10, 20-30
I'm pretty familiar with =RAND and also have the Analysis Toolpak installed
many thanks
Chris