I am attempting to remove blank cell values which also have a formula, from a column in OpenOffice calc.
Row numbers and corresponding data:
1 A1 2 A4 3 4 A9 5 6 A98
Each cell in the data column has a formula, so technically they are not blank, but no data shows in the sheet for certain rows.
fwiw, the formula finds unique values of two other columns and copies these to a third column:
Here's my example sheet.
So far I've tried adding a Standard Filter by selecting the data column then going to
Standard Filter, choosing the data column, setting condition to
=, value to
Not Empty, then selecting the
Copy to option and pointing to a cell in an empty column in the sheet. Obviously this doesn't work since my cells have a formula in them.
Is there a similarly easy method to do the same thing with cells containing a formula, but where no data exists in the sheet for the same cell?