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

"Max" wrote:

"B.J" wrote:
.. What I want is to show 1-55 in a colum
and when i hit F9 the whole colum changes.

But isn't that what col B (B1:B55)
in the suggested set-up delivers ?

(You could always hide away cols A & C)
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--