I use a formula like so
=IF(F8="HTL",A8,"")
This is in P3 and copied down, when I copy the range as Values to another sheet and then do ctrl+G, Special then Blanks. It cannot find the blanks. Is there a way to clear contents on the cells that have no text ?
=IF(F8="HTL",A8,"")
This is in P3 and copied down, when I copy the range as Values to another sheet and then do ctrl+G, Special then Blanks. It cannot find the blanks. Is there a way to clear contents on the cells that have no text ?