One other thing. There are multiple entity numbers in the list (123456 will
change to a new entity number) and the account numbers will repeat for each
entity. That is there will be an account 0100-0210 Purchase with an Asset
Value and and Accum Depr number for each entity. I need to subtotal each
account number within each entity and then move those subtotals to a new list
(or alternatively, delete the detail data out of this list) in order to
compare it to the list from the other system.

Thanks for your help.

"TJN" wrote:

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