Hi
enter the following in A4
=IF(ISNUMBER(B4),B4,"")
and copy down for all rows

--
Regards
Frank Kabel
Frankfurt, Germany


Blue wrote:
Hi

What I would like to do is

Starting at B4, if B4 has a number in it enter 1 in column A row same
as B repeat to end of column B

Thanks in advance

Blue