Home |
Search |
Today's Posts |
#1
|
|||
|
|||
subtotaling and manipulating a list of data
I have a list of data that I need to subtotal Asset value and Accum dept each
time the acct # field changes. What I need to do is get the subtotal values into a new list that I can compare to data from another system. That is the data from the other system is already totaled by acct # within each entity. The data from these two systems is supposed to be equal - I am searching for differences so I can get them corrected. I want to combine the two lists and then use conditional formatting to flag the non matching data. I have tried the subtotal function, but I need the entity number and acct # to appear in the subtotal line that needs to go to the list I compare to the other system's data. Any ideas? Entity Acct # Desc Asset Value Accum Depr 123456 0100-0210 Purchase 5,370,223.29 417,906.08 123456 0100-0210 Add'l Building cost 5,391.76 419.65 123456 0100-0210 Add'l Building 4,583.58 356.87 123456 0100-0210 FAS Buildin (581,540.84) (40,045.72) 123456 0100-0310 Gen'l Imp 3,633.23 121.11 123456 0100-0310 Gen'l Imp 1,165.00 38.84 123456 0100-0310 New HVAC Unit #5 4,798.00 79.97 123456 0100-0405 Interior Painting 4,200.00 1,330.00 123456 0100-0405 TI Costs 4,166.53 972.25 123456 0100-0405 TI-Sunamerica 172,126.54 37,294.12 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
subtotaling and manipulating a list of data | Excel Worksheet Functions |