One play if you want it to be random but non-repeating ..

Assume source data within A1:A6

In B1: =INDEX(A:A,RANK(C1,$C$1:$C$6))
In C1: =RAND()
Select B1:C1, fill down to C6

B1:B6 will return a random shuffle of what's in A1:A6
Each press of the F9 key will regenerate a fresh shuffle
(Hide away col C, if necess)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Sumeet Benawra" wrote:
> Hi
>
> I want to be able to create a random values from a given list of values.
>
> e.g. In column A, there are these values:
> aaaa
> bbbb
> cccc
> dddd
> eeee
> ffff
>
> In another column, I want to randomly populate each cell with a value from
> column A.
>
> How can I do this?
>
> Thanks