Generate Random Qualitative Data in Excel with CHOOSE()

What’s the only thing better than real data?

Fake data! Well, at least sometimes — such as for conducting training or testing models.

Subscribe to the newsletter for more Excel tips and tricks. Plus, your free ebook!

You may know about¬†RANDBETWEEN( ), Excel’s built-in nifty random number generator, to mock up quantitative data.

But what if we want qualitative data: that is, a color or location? 

Turns out we can use RANDBETWEEN( ) in combination with a little-known Excel function to achieve this result.

Check out the video:


Download the exercise file here.


Subscribe to my mailing list.


  1. Or dump the categories into a column, and use INDEX(RANDBETWEEN)

Leave a Reply

%d bloggers like this: