Hello

D

DLL

I am a new excel user;
How would I use a vlookup and rand to reassign numbers say 1-5. Each would
have an equal chance. Looking for a formula that would accomplish this task.
Thanks for any help
 
M

Max

One easy & fast formulas set-up which delivers it ...
Source items assumed in A1:A5, eg the numbers: 1 - 5
In B1: =RAND()
In C1: =INDEX($A$1:$A$5,RANK(B1,$B$1:$B$5))
Copy B1:C1 down to C5. Hide col B. C1:C5 gives you a random scramble of the
items in A1:A5. Press F9 to regenerate a fresh scramble.

voila? Hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
 
M

Max

DLL said:
I really need to use vlookup with rand though. Any input will help.

well, I'm not sure. Guess you could have a go with this:
=VLOOKUP(RAND()*4,{0,1;1,2;2,3;3,4;4,5},2)

You could generate a random integer between 1-5 using simply:
=RANDBETWEEN(1,5)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top