end of data block in excel

[CaitlinWhybrow]

Hello

Is there a way of finding the row on which a block of data ends? The first line of the data doesn't always start on the same row, and the data is varies in length. (the first row of data includes "surname" and I found that using GlennUK's tip).

THANK YOU!

 

[SkipVought]

Hi,

How can I rename a table as it changes size faq68-1331

If you can find the first row, then COUNTA should give you the number of rows of data assuming that each row in the range has values.

Skip,

_{[red]A palindrome gone wrong?[/red]
A man, a plan, a ROOT canal...
PULLEMALL!}

 

[AnotherHiggins]

CaitlinWhybrow,

Are there empty cells in the column you wish to examine?

[tt]_____
[blue]-John[/blue]
[/tt][red]Quidquid latine dictum sit, altum viditur[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[CaitlinWhybrow]

Yes - there are blanks in the column and I just want to select the first block of data. The position of the first row of the data varies, but has the first row always contains the text "surname", so I am able to locate it.