Return empty cell from formula in Excel - Stack Overflow

IF(some_condition,EMPTY(),some_value) ... You're going to have to use VB, then . You'll iterate over the cells in your range, test the condition, and delete the ...

stackoverflow.com