abdulkarim1983
New Member
Hi
I have a workbook that records purchase invoices from suppliers.
There are 2 columns: Column A = Supplier and Column B = Amount
Sometimes an item is purchased but subsequently refunded. As a result we have a purchase (for say $500) and a credit (of -$500) which net to zero. Such items are called 'contras' as they net to zero.
Now what I need to do is identify all the contra entries in the spreadsheet. However, the condition is that to numbers which net to zero can only be a contra if they are from the same supplier.
Can anyone please help me find a way to do this?
e.g. The contra items below are lines 1&4 and 5&6 (2&3 don't contra as they are from different suppliers).
JAMES MORGAN -2,100.00
JAMES MORGAN 5,678.00
THINK PUBLISHING LTD -5,678.00
JAMES MORGAN 2,100.00
EXPERIAN LTD -2,176.47
EXPERIAN LTD 2,176.47
Your help is very much appreciated.
Thanks
I have a workbook that records purchase invoices from suppliers.
There are 2 columns: Column A = Supplier and Column B = Amount
Sometimes an item is purchased but subsequently refunded. As a result we have a purchase (for say $500) and a credit (of -$500) which net to zero. Such items are called 'contras' as they net to zero.
Now what I need to do is identify all the contra entries in the spreadsheet. However, the condition is that to numbers which net to zero can only be a contra if they are from the same supplier.
Can anyone please help me find a way to do this?
e.g. The contra items below are lines 1&4 and 5&6 (2&3 don't contra as they are from different suppliers).
JAMES MORGAN -2,100.00
JAMES MORGAN 5,678.00
THINK PUBLISHING LTD -5,678.00
JAMES MORGAN 2,100.00
EXPERIAN LTD -2,176.47
EXPERIAN LTD 2,176.47
Your help is very much appreciated.
Thanks