I have two spread sheets that I combine. One is openinvoices and the other is payments, so I have a spread sheet with all open invoicesand payments for invoices that were paid that day. Is there a way to remove theinvoices that were paid without having to go through and select every line anddelete the rows manually? So I have column B (invoice #) and column D (invoice/payment$) if these two match exactly I want these rows removed, there may be severhundred that meet this requirement on this spread sheet.
<tbody>
</tbody>
Customer Name | Invoice # | Date | Amount |
AAA | 1001 | 5/1/13 | $500.00 |
1001 | $500.00 | ||
BBB | 1002 | 6/1/13 | $450.00 |
CCC | 1003 | 7/1/13 | $250.00 |
DDD | 1004 | 6/15/13 | $100.00 |
<tbody>
</tbody>