Bob789
02-13-2019, 07:04 PM
Can someone tell me how in Excel, through formulas and/or filters or some other function, I can get the total dollar amount for each charge description for each address with table A being the original source data and table B being the extracted output as shown below. Thank you.
Table A Data
Address
Charge Description
Amount
1303 W Clinton Dr Unit 109
Assessments
245
1303 W Clinton Dr Unit 109
Lockbox Payment
-245
1303 W Clinton Dr Unit 109
Assessments
245
1303 W Clinton Dr Unit 109
Late Fee
10
1303 W Clinton Dr Unit 109
Late Interest
7.35
1303 W Clinton Dr Unit 109
Lockbox Payment
-245
1303 W Clinton Dr Unit 109
Lockbox Payment
-245
1303 W Clinton Dr Unit 109
Assessments
245
1303 W Clinton Dr Unit 109
Late Fee
10
1303 W Clinton Dr Unit 109
Late Interest
3.94
1303 W Clinton Dr Unit 110
Assessments
245
1303 W Clinton Dr Unit 110
Lockbox Payment
-245
1303 W Clinton Dr Unit 110
Assessments
245
1303 W Clinton Dr Unit 110
Lockbox Payment
-245
1303 W Clinton Dr Unit 110
Assessments
245
1303 W Clinton Dr Unit 110
Late Fee
10
1303 W Clinton Dr Unit 110
Late Interest
3.67
1303 W Clinton Dr Unit 110
Lockbox Payment
-245
1303 W Clinton Dr Unit 110
Assessments
245
1303 W Clinton Dr Unit 110
Lockbox Payment
-245
Table B Result
Address
Charge Description
Amount
1303 W Clinton Dr Unit 109
Assessments
735
1303 W Clinton Dr Unit 109
Late Fee
20
1303 W Clinton Dr Unit 109
Late Interest
11.29
1303 W Clinton Dr Unit 109
Lockbox Payment
-735
1303 W Clinton Dr Unit 110
Assessments
980
1303 W Clinton Dr Unit 110
Late Fee
10
1303 W Clinton Dr Unit 110
Late Interest
3.67
1303 W Clinton Dr Unit 110
Lockbox Payment
-980
Table A Data
Address
Charge Description
Amount
1303 W Clinton Dr Unit 109
Assessments
245
1303 W Clinton Dr Unit 109
Lockbox Payment
-245
1303 W Clinton Dr Unit 109
Assessments
245
1303 W Clinton Dr Unit 109
Late Fee
10
1303 W Clinton Dr Unit 109
Late Interest
7.35
1303 W Clinton Dr Unit 109
Lockbox Payment
-245
1303 W Clinton Dr Unit 109
Lockbox Payment
-245
1303 W Clinton Dr Unit 109
Assessments
245
1303 W Clinton Dr Unit 109
Late Fee
10
1303 W Clinton Dr Unit 109
Late Interest
3.94
1303 W Clinton Dr Unit 110
Assessments
245
1303 W Clinton Dr Unit 110
Lockbox Payment
-245
1303 W Clinton Dr Unit 110
Assessments
245
1303 W Clinton Dr Unit 110
Lockbox Payment
-245
1303 W Clinton Dr Unit 110
Assessments
245
1303 W Clinton Dr Unit 110
Late Fee
10
1303 W Clinton Dr Unit 110
Late Interest
3.67
1303 W Clinton Dr Unit 110
Lockbox Payment
-245
1303 W Clinton Dr Unit 110
Assessments
245
1303 W Clinton Dr Unit 110
Lockbox Payment
-245
Table B Result
Address
Charge Description
Amount
1303 W Clinton Dr Unit 109
Assessments
735
1303 W Clinton Dr Unit 109
Late Fee
20
1303 W Clinton Dr Unit 109
Late Interest
11.29
1303 W Clinton Dr Unit 109
Lockbox Payment
-735
1303 W Clinton Dr Unit 110
Assessments
980
1303 W Clinton Dr Unit 110
Late Fee
10
1303 W Clinton Dr Unit 110
Late Interest
3.67
1303 W Clinton Dr Unit 110
Lockbox Payment
-980