Counting rows until a blank row

[sh1]

Hi
I want to be able to count the number of rows until I hit a blank row, and use the counter as an index. How is that possible?
I have a no. of rows that are fulled, followed by a blank row then another set of rows that are filled then a blank row etc. I want to count the rows filled till the blank row and set the counter to that number. Then I want to do the same with the next set of rows etc.
Any solution will be appreciated
TIA
Steve

[FDibbins]

if you want consecutive numbers until a blank cell, then start again numbering after the blank, try this in a helper column. Assuming your data starts in A1, put this in B2, copied down...
=IF(A2="",0,1+B1)

[sh1]

Thanks for your reply. I do not want consecutive numbers until a blank cell, what i want is the total row count returned in a cell. The row count no. of rows till a blank row. for example if i have 18 rows filled up with data and the 19th is blank, then my cell counter should have the number 18 in it.
thanks

[jeffreybrown]

How about...

Please Login or Register  to view this content.

...where you data is in column A down to row 18, row 19 is blank and then row 20 starts up again with data