# Matching data

Closed
Beth - Feb 14, 2010 at 08:23 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 16, 2010 at 04:09 AM
Hello,

Can anybody help me to simplify my work in matching debits and credits? For example in one column all I need are items that do not have a matched.

Column A
-10
3
2
5
-3
-2
10

In the above data, -10 and +10 will be zero out as well as those data with corresponding debits and the outstanding will 5. Is there a possible formula forthis?

Thanks

## 2 responses

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Feb 15, 2010 at 05:37 AM
why not just add the column A. you will get 5
I do not need the sum of items that have a match, I need each line item that do not have a match. See given data below.
A B C
10/23/2009 BND (30,394.01)
10/23/2009 BND (162,388.70)
10/23/2009 BND (26,049.72)
10/23/2009 BND (178,440.80)
10/23/2009 BND (11,206.08)
10/23/2009 BND 456,550.97
10/23/2009 BND (20.40)
10/23/2009 BND 32,452.15
10/23/2009 BND 25,747.36
10/23/2009 USD (22,934.38)
10/23/2009 USD (18,196.01)
10/23/2009 USD (33,972.90)
10/30/2009 USD 22,934.38
10/30/2009 USD 18,196.01
10/30/2009 USD 33,972.90
10/30/2009 BND 32,452.15
10/30/2009 BND 25,747.36
10/30/2009 BND 48,071.65
10/30/2009 BND (32,452.15)
10/30/2009 BND (25,747.36)
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Feb 16, 2010 at 04:09 AM
I would guess you want not only amount to offset each other but also the currency to be same ?
BND amount should offset same BND amount and USD should do for USD ? would that be right ?