G
gary c
How can I count the rows starting with the cell containing
"ASSESSMENT
NUMBER" through the next cell containing "PAID STATUS"? Then, how
can I assign the resulting count to the rows upon which that count
was
derived? (For example, the the first count would be 4 so 4 would be
assigned to those four rows).
Here's my spreadsheet:
A
ASSESSMENT NO 001310350-1 TAX YEAR 2008 TAXABILITY CD 0-00
70-0012 13.00 .00
70-0015 24.50 .00
PAID STATUS UNPAID
ASSESSMENT NO 001310350-1 TAX YEAR 2009 TAXABILITY CD 0-00
70-0012 13.00 .00
70-0015 21.00 .00
PAID STATUS UNPAID
ASSESSMENT NO 001310350-1 TAX YEAR 2010 TAXABILITY CD 0-00
70-0012 13.00 .00
70-0015 21.25 .00
PAID STATUS UNPAID
ASSESSMENT NO 001310350-1 TAX YEAR 2011 TAXABILITY CD 0-00
70-0012 13.00 .00
70-0015 21.50 .00
PAID STATUS UNPAID
ASSESSMENT NO 001310366-6 TAX YEAR 2008 TAXABILITY CD 0-00
70-0012 13.00 .00
70-0015 24.50 .00
70-0016 222.50 .00
70-0060 .00 .00
PAID STATUS UNPAID
ASSESSMENT NO 001310379-8 TAX YEAR 2009 TAXABILITY CD 0-00
70-0012 13.00 .00
70-0015 21.00 .00
PAID STATUS UNPAID
ASSESSMENT NO 001310379-8 TAX YEAR 2010 TAXABILITY CD 0-00
70-0012 13.00 .00
70-0015 21.25 .00
PAID STATUS UNPAID
ASSESSMENT NO 001310379-8 TAX YEAR 2011 TAXABILITY CD 0-00
70-0012 13.00 .00
70-0015 21.50 .00
PAID STATUS UNPAID
ASSESSMENT NO 001310380-8 TAX YEAR 2008 TAXABILITY CD 0-00
70-0012 13.00 .00
70-0015 24.50 .00
PAID STATUS UNPAID
ASSESSMENT NO 001310380-8 TAX YEAR 2009 TAXABILITY CD 0-00
70-0012 13.00 .00
70-0015 21.00 .00
PAID STATUS UNPAID
"ASSESSMENT
NUMBER" through the next cell containing "PAID STATUS"? Then, how
can I assign the resulting count to the rows upon which that count
was
derived? (For example, the the first count would be 4 so 4 would be
assigned to those four rows).
Here's my spreadsheet:
A
ASSESSMENT NO 001310350-1 TAX YEAR 2008 TAXABILITY CD 0-00
70-0012 13.00 .00
70-0015 24.50 .00
PAID STATUS UNPAID
ASSESSMENT NO 001310350-1 TAX YEAR 2009 TAXABILITY CD 0-00
70-0012 13.00 .00
70-0015 21.00 .00
PAID STATUS UNPAID
ASSESSMENT NO 001310350-1 TAX YEAR 2010 TAXABILITY CD 0-00
70-0012 13.00 .00
70-0015 21.25 .00
PAID STATUS UNPAID
ASSESSMENT NO 001310350-1 TAX YEAR 2011 TAXABILITY CD 0-00
70-0012 13.00 .00
70-0015 21.50 .00
PAID STATUS UNPAID
ASSESSMENT NO 001310366-6 TAX YEAR 2008 TAXABILITY CD 0-00
70-0012 13.00 .00
70-0015 24.50 .00
70-0016 222.50 .00
70-0060 .00 .00
PAID STATUS UNPAID
ASSESSMENT NO 001310379-8 TAX YEAR 2009 TAXABILITY CD 0-00
70-0012 13.00 .00
70-0015 21.00 .00
PAID STATUS UNPAID
ASSESSMENT NO 001310379-8 TAX YEAR 2010 TAXABILITY CD 0-00
70-0012 13.00 .00
70-0015 21.25 .00
PAID STATUS UNPAID
ASSESSMENT NO 001310379-8 TAX YEAR 2011 TAXABILITY CD 0-00
70-0012 13.00 .00
70-0015 21.50 .00
PAID STATUS UNPAID
ASSESSMENT NO 001310380-8 TAX YEAR 2008 TAXABILITY CD 0-00
70-0012 13.00 .00
70-0015 24.50 .00
PAID STATUS UNPAID
ASSESSMENT NO 001310380-8 TAX YEAR 2009 TAXABILITY CD 0-00
70-0012 13.00 .00
70-0015 21.00 .00
PAID STATUS UNPAID