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:*
`=IFERROR(INDEX($A$1:$A$100,AGGREGATE(15,6,1/(1/(ISNA(MATCH($A$1:$A$100,$B$1:$B$100,0))*ROW($A$1:$A$100)*($A$1:$A$100<>""))),ROWS($1:3))),"")`

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?

Data -> Filter -> AutoFilteras explained at askubuntu.com/questions/943662/…. – Jim K Feb 10 '18 at 9:43