Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hello
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hello
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" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hello
Thanks Max, you've helped me before! You did again! Thanks again!
"Max" wrote: 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" wrote: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hello
I really need to use vlookup with rand though. Any input will help.
"Max" wrote: 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" wrote: 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. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Hello
"DLL" wrote:
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 --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|