"Tonto" wrote in message
oups.com...
Hi Bruno

Because the data in column one comes from somewhere else it doesnt
work.

John

This is not a good reason.
My data in column one come half from another computer
on my lan, half from another (closed) file on my computer
and the formula works!

Something else must be wrong over there.

Bruno