Instead of using a array formula, you could use the
COUNTIF() function to check for duplicates. Assuming this sample data:
You can add a flag in Column
C indicating duplicates in Col.
A using this formula in
C2, and copying it down:
This results in:
Now, you can add a second "flag column", combining the boolean value of col
C with a check for
Now, we have:
Of course, you could combine both formulae - the result (again for
row 2) may look like:
As result, you have an additional column with a
TRUE flag for all rows that are duplicates and have an
amount > 0. Now, you can apply an
AutoFilter (Menu "
Date" -> "
Filter" -> "
AutoFilter") and filter for rows with that
(tested with LO Calc - should work the same way using OOo Calc).