From your subject line:
How do I set up a random Colum 1-55 without repeating a number
(Note that you should always write the full query within the message area)

One interp & way to set it up ..

Put in
A1: =ROW(A1)
B1: =INDEX(A:A,RANK(C1,$C$1:$C$55))
C1: =RAND()

Select A1:C1, copy down to C55

B1:B55 will return a random shuffle of the numbers 1 - 55 from col A
(Replace the formula in A1:A55 with whatever 55 items that's to be shuffled)

Press F9 to regenerate afresh
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"B.J" wrote in message
...