Type your search here:
Search
i.e.: skype, chrome, uTorrent

Greater Randomization Capabilities in Excel

 

Choosing random numbers can come in handy in all sorts of Excel applications, uses, and purposes. However, basic Excel offers rather limited randomization capabilities, which pretty much sum up to two functions: RANDBETWEEN which chooses a random number between two specified numbers, and RAND which returns a random number greater than or equal to 0 and less than 1, evenly distributed.

But what happens when you need to randomly choose a value from an array of cells? What happens when you need to choose a random number from a specific set of values and not all integer numbers between two given numbers?

Towards that end PowerUps has developed two neat functions: pwrRANDFROMSET and pwrRANDFROMRANGE.

Both functions can be accessed by choosing the 'PowerUps' option from the main tool bar:

 

 

Randomization

 

And then by selecting the 'PowerUps Functions' option:

 

 

Randomization capabilities

 

Then, select the 'Randomizer' option which will lead you to a new menu. From this new menu you can choose either one of these functions:

 

 

Excel randomization process

 

pwrRANDFROMSET

This function chooses a random number from a given set of values. You can type in the desired set of values and have the function choose a random number for you:

 

 

Excel randomization

 

pwrRANDFROMRANGE

This function chooses a random number from a given range of cells. Simply select the desired cells and let the function randomly choose the value of one of these cells for you:

 

 

Randomization results

 

And, you're done! Now you can enjoy greater randomization capabilities in Excel than ever before!

Good luck!

 

Astro Newsletter

Enter your email address
I'd like to hear about cool new stuff
I’d also like to receive free games, demos and other fun offers
Subscribe
We will respect your privacy
Our monthly Newsletter will take you to the moon...
Well, maybe not, but you will discover some great new programs you can get and do amazing stuff with, and it will keep you up to date with all the hottest stuff. It is easy to unsubscribe, so why not give it a try?