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.