exceltoxl.com

Hi there,

We all know RANDBETWEEN works only with numbers. But, why am I saying we can do random pic words using RANDBETWEEN. Is there any way we can do this? If you have any idea before reading the complete post, leave your idea using below comments section. 

If you are new to this tip, walk with me.

Learn Formulas from here. We have FORMULAS CRASH COURSE tailored for you; try once if you like it.

RANDBETWEEN WORKS WITH NUMBERS:

...

As I already mentioned, this function works only to list the values in a cell randomly. This function is a very simple but very useful function (time saving function in many cases) when creating dummy data for experimenting on few of the features in Excel. This function helps to randomly pic one of the given scenarios and displays in the cells. It doesn't follow any particular method while displaying the random figures.  

This is a basic introduction about RANDBETWEEN.

RANDBETWEEN WORKS WITH WORDS / CHARACTERS:

Here, say we have two genders and it has to be displayed randomly. So, we have either Male or Female version. Right? To do this, we will use CHOOSE function to work with words/characters to display randomly. Here how it is:

=CHOOSE(RANDBETWEEN(1,2),"Male","Female")

HOW THIS FORMULA WORKS:

CHOOSE function helps to choose the word related to what number RANDBETWEEN displays in INDEX PLACE. Say RANDBETWEEN displays 1 then CHOOSE will take MALE else 2 as FEMALE.

That's it. Magic Works!!!

DID YOU USE RANDBETWEEN?

If you have anything to share regarding this post, please feel free to post your comments, ideas, suggestions, or anything using below comments section.

If you like this post, please do share it on your social networking sites just by clicking on the icons placed around the blog.

If you want to support me for maintaining this blog, REGISTER here for free. You will be receiving all latest updates directly to your registered mail. We strongly follow data security.

SOME IMPORTANT LINKS:

How to Get Decimals using RANDBETWEEN

Information Functions Week

Test Cases can be changed Before Changing UnderPants

Count Worksheets in Workbook

Extract Sheetname to a Cell

Thanks,