Hi,
You cannot remove blank rows using a formula.
You have to perform one of the following actions:
(1) Delete the blank rows (for example, via filtering); or
(2) Sort the column (this will "push" the blank rows to the bottom).
Both of these options can be automated using VBA if necessary.
|