I have a 35k record sheet with house tax bills for my city. I have excel 07 and can't get the colo's html maker to work well so I have to try and type it. Sorry
Col a has the property's parcel id number it is referred to as pid. Each pid can appear up to 10 times on the sheet because we downloaded all unpaid tax bills for the last 10 years. each record no matter how many times it appears has the same info accross the sheet cols all the way to col v with info like situs address mailing address amount owed for that year etc.
I need a formula that will take each pid record if there is more than 1 and total all the taxes owed that appears in col s and give that result but only pull in the rest of the info for that record 1 time. making it one record but with the taxes totaled.
Since they show the amount owed on a per year basis if there is more than 1 year it makes multiple records. I do not need the years to appear. Just the number of years ie how many records there were that were combined and the total taxes owed.
Col a has the property's parcel id number it is referred to as pid. Each pid can appear up to 10 times on the sheet because we downloaded all unpaid tax bills for the last 10 years. each record no matter how many times it appears has the same info accross the sheet cols all the way to col v with info like situs address mailing address amount owed for that year etc.
I need a formula that will take each pid record if there is more than 1 and total all the taxes owed that appears in col s and give that result but only pull in the rest of the info for that record 1 time. making it one record but with the taxes totaled.
Since they show the amount owed on a per year basis if there is more than 1 year it makes multiple records. I do not need the years to appear. Just the number of years ie how many records there were that were combined and the total taxes owed.
| 10Yr_Unpds.xls | ||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | |||
| 1 | TAXPID | LANDUSECOD | txt_tax_bill_year | txt_nme_taxpayer | num_street | cde_street_dir | txt_nme_street | cde_street_type | txt_unit | txt_addr_1 | txt_addr_2 | txt_nme_city | txt_cde_state | cde_zip_1 | cde_zip_2 | nme_contact_person | amt_amount_due | txt_mortgage_year | txt_mortgage_co_num | txt_parcel | ||||
| 2 | 00101349 | R120 | 2007 | PIERREJOSEPHB | 13711 | HAGERSFERRYRD | 13703HAGERSFERRYRD | HUNTERSVILLE | NC | 28078 | 577.88 | 2007 | 00101349 | |||||||||||
Select1 | ||||||||||||||||||||||||
