Hi,
in cells A71:A140 I have the following formula: =IF(A4<>"";A4;"").
How can I select only the cells in range A71:A140 where the formula has returned a value
(number or text) and not the blank cells? When I try ctrl + shift + down arrow,
all cells in the range are selected...
in cells A71:A140 I have the following formula: =IF(A4<>"";A4;"").
How can I select only the cells in range A71:A140 where the formula has returned a value
(number or text) and not the blank cells? When I try ctrl + shift + down arrow,
all cells in the range are selected...