There may be a more efficient way but I'd turn on the filter, then filter on
the credit column for each value and then filter on the debit column for the
same value. Remember that regardless of the order of the data, Filter always
displays the selection in numeric / alpha order from low to high. So when
you filter on Credit the first selection should be 0, because it's the lowest
number. Then filter on Debit for any 0 entries there. Any that match, I'd
highlight the whole row, select visible cells and then delete.

Unfilter on the debits and update your Credit filter to the next value, then
re-filter on the debits, then delete any matches. You should be left with
only non-matching values.

To select visible rows, once you highlight them click Edit (from the pull
down menu) then choose Go To, then choose Special, then click the radio
button for Visible Cells Only (then click OK). When done, you can delete
knowing you are deleting only the rows you want and not mistakenly
eliminating any data in between that might not see.

A super quick way to do this is, after you highlight the rows is Alt-E, then
G, then Alt-S, then Y, then (enter). Much faster than all the clicks.

Good luck!

"Neo" wrote:

Hi,
I have a spreadsheet with debit and credit columns and I need to cancel out
rows that equal the debit and credit columns.

Example:
A B
1 Credit: Debit:
2 15 0
3 15 0
4 10 0
5 0 12
6 12 0
7 13 0
8 14 0
9 0 15
10 0 15

In this scenario, I'm deleting rows 2,3,5,6,9 and 10 because they cancel out
each other in the debit and credit columns. Now I'm doing this manually
because I cannot come up with a formula that will delete the ROWS that match
the DEBIT AND CREDIT COLUMNS. I really would appreciate it if somone could
help me with a formula to delete only the rows that match DEBIT AND CREDIT.