Hello

  • Thread starter Thread starter DLL
  • Start date Start date
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
 
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
 
DLL said:
I really need to use vlookup with rand though. Any input will help.
Click to expand...

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
---
 
Back
Top