Hankins
07-28-2009, 04:58 AM
I have two columns of data that are related. I have a cost code column and a cost column. I may have several rows that share the same cost code. I need to be able to generate a list of the codes used and the total cost for each.
>>> Raw Data
Cost Code ---------- Cost
11007 --------------- $1500
11500---------------- $1000
11007---------------- $10000
10540---------------- $200
11500---------------- $500
This list could be 20 - 30 rows longer
>>> Output
11007---------------- $11500
11500---------------- $1500
10540---------------- $200
Hook a brotha up! Thanks for your help!
:beerchug:
>>> Raw Data
Cost Code ---------- Cost
11007 --------------- $1500
11500---------------- $1000
11007---------------- $10000
10540---------------- $200
11500---------------- $500
This list could be 20 - 30 rows longer
>>> Output
11007---------------- $11500
11500---------------- $1500
10540---------------- $200
Hook a brotha up! Thanks for your help!
:beerchug: