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 |
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. |
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. |
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. |
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 --- |
All times are GMT +1. The time now is 02:31 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com