Generate a Random Number but Exclude Some Numbers

This is going to be an exclusive video...well basically it's going to show you how to create random numbers and exclude a number (or set of numbers) from that list. There are three examples that I'll show. One showing how to exclude odd or even numbers from a random number list. The second will show how to exclude a set of numbers from a larger list. And the last example will show how to randomly generate a number in two steps but with in the second instance, it can not be a repeat of the first randomly generated number. Check out the video for the random goodness.

P.S. One thing to note on the first example is that you could get a number that is outside the RANDBETWEEN range (1 to 100) in the ODD number example. In that case it can be wrapped in an IF function to mitigate it. The function could be like =IF(ODD(RANDBETWEEN(1,100))=101,ODD(RANDBETWEEN(1,100)),ODD(RANDBETWEEN(1,100)))

🔔 SUBSCRIBE to my channel ➜ https://goo.gl/wN3c3p

🏫 Excel Training ➜ https://www.exceltraining101.com/p/tr...

📚 Excel Books & Tech Gear ➜ https://www.amazon.com/shop/dough

⚙️ Tools: Screencasting ➜ https://techsmith.z6rjha.net/5Qe53

⚙️ Tools: Microsoft Office ➜ https://microsoft.msafflnk.net/rKL0G

⚙️ Tools: TubeBuddy ➜ https://www.tubebuddy.com/et101

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

🎁 If you find these videos useful and want to support my channel go to   / doughexcel  

#excel
#msexcel
#doughexcel

~-~~-~~~-~~-~
Please watch: "Convert Table in a PDF File to Excel"
   • Convert Table in a PDF File to Excel  
~-~~-~~~-~~-~