"B.J" wrote
No B shows individual numbers
also it repeats numbers befor the whole list is shown.

Guess I'm not sure what happened over there <g

Here's a sample implementation to play with:
http://cjoint.com/?lohRA4AVqG
Set_up_a_random_col_1-55_without_repeating_a_number_BJ_misc.xls

The randomized numbers 1 - 55 within B1:B55 **do not repeat**

**Prove this easily for yourself by copying B1:B55, then paste special as
"values" in another col, and then sort that col in ascending order.

Pressing F9 will produce another random shuffle of the numbers
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--