I use a formula to copy certain cells.=IF(A9>5,A9,"")
When I copy and PASTE VALUES to another cell, the cells with no data are not blank. This is causing me problems later when I want to test for ISBLANK.
I assume because it is putting "" in the cell but I can't see it.
Is there a better way to do this?
Thanks.
Bookmarks