Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Counting rows
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting characters in multiple rows when rows meet specific criteria | Excel Worksheet Functions | |||
Counting Rows | Excel Discussion (Misc queries) | |||
Counting rows, then counting values. | Excel Discussion (Misc queries) | |||
Counting Rows Then Counting Values in Columns | Excel Programming | |||
Counting Rows | Excel Discussion (Misc queries) |