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
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 16, 2010 at 04:09 AM
Related:
- Matching data
- Tmobile data check - Guide
- Transfer data from one excel worksheet to another automatically - Guide
- How to be offline in whatsapp when data is on - Guide
- Data transmission cable - Guide
- Spectrum data usage - Guide
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
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)
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
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 ?
BND amount should offset same BND amount and USD should do for USD ? would that be right ?
