Matching data Closed

Question

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

venkat1926 · Answer

why not just add the column A. you will get 5

Beth · Answer

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)

Matching data

2 responses

Similar discussions

Subscribe To Our Newsletter!