Hi,
I really need to help with this.
As the title says I want to insert a 1 into another column (column B) where only where number values are detected in column A. I have tried the function but I want the cells in column B to be empty if text is detected in Column A.
=IF(ISNUMBER(F4), 1, 0)
I would be grateful if someone could help. Thanks
Leinster
Bookmarks