Generate a list of random numbers instantly for your research!

Time to learn: 20 minutes

So, what is this?


RAND is a function that gives you a set of random numbers from between 0 and 1. Here’s an example:


Function RAND


This is a function that gives you more control when you want random numbers…which is kind of a oxymoron.

So, here’s an example:



This gives you a random number between, yup, 1 and 10. Copying the contents of the cell give you more random numbers in this range.  If you’d like a different set of numbers, just press F9.

Here’s something extra:

=LARGE(ROW($1:$9)*NOT(COUNTIF($A$1:A1, ROW($1:$9))), RANDBETWEEN(1,10-ROW(A1)))

Function RANDBETWEEN Unique

Put this formula in cell A2 and instead of just pressing ‘Enter’, press ‘Ctrl+Shift+Enter’.

This gives you a formula that produces 1-9 in a random order, with no repeated numbers.  I didn’t come up with this though, but it is cool.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s