How to generate a Random List in Excel

http://www.xlninja.com/2012/06/13/how-to-generate-a-random-list-in-excel/

A video on how to generate a random list in Microsoft Excel using a combination of the RANDBETWEEN function and the VLOOKUP function.

---

Closed Caption:

hello this is other from xcel ninja .
com
today I'm going to show you how to
create a random list there from a
starting point that is this particular
list of 27 so names and could be
customers it could be people working in
your company and you want to create a
really long lace that is in a random
order just basically starting from this
27 so name
so what you'll do as you can see after
reading here you put a number next to
the list of certain from 12 in this case
27 and this will form the basis of the
field cup function it will be using
next let's say that you want to create
the list employee here in these two
columns and go
gone forever and ever if you need a
thousand hundred or thousand values
it doesn't matter you can do how many
you want what you'll do you'll select
the ran between function RND RND between
and what Excel house keys to basically
select a bottom and a top number there
he will choose our a random number
between so in our case it will be 1 and
27 we choose the arranger we have closed
parenthesis and you got as you can see
it
giving us to the first number
what at the particular thing about this
random between function is that gives
you integers and excuse me
it gives you integers as opposed to the
ra n dear and function because that will
give you from 0 to 1 in this case you
can select the bottom and the top value
that you want a random number in between
having said that so you got number two
once you have this number two then you
can create use a V look like a lookup
function the lookup function where you
basically tell Excel can look up this
number and you want to you to have gone
up a look in this range
so you select the whole range and then
you fix it with a full so that
d 4 + e 30 are fixed and then the next
thing you'll say i want the second value
of that range to appear in the in that
particular cell so as you can see now
it's 21 and it goes in pick number 21
and it's Smith as you can see
so we'll what we'll do now will copy and
we'll can go for on forever ever
however you want paste in there you go
that's your random list so basically
could for instance be a randall list of
customer calls or things like that
what there's a few things to clarify
about this as you can see this every
time there for instance you press s9
Excel will update reaches the three
select the fresh fresh list
essentially so that you can basically
update the list as you wish
if you want to make it permanent you
just copy you go to the right
for instance are you a special price
values and that's it
as you can see this has been updated
once again whereas this one is now fixed
in time and you can use it for whatever
purpose you want
so again just to summarize the function
that you want his ran between random
between
and you choose the top and the bottom
values in these four in in this instance
is 127 which gives us then arrange that
we can choose from to use in the vlookup
function that basically gives us the the
ability to generate a random list