Floating Dynamic named range

[sotiris5000]

Hello,

This is my first post.

I need some help with a named range and how to make it dynamic.
I have a series of data in column B and I need the range to capture it all. The problem is, the data series starts on a different row each time. So, sometimes the data will be in rows 25 to 100, another time it will be rows 34 to 75.
I know I can use offset to count down to the last used row, but for the life of me I can't figure out how to make the range figure out where the range starts (i.e. The first used row).

Does anyone have any ideas? It seems like there's a wealth of stuff on line about finding the last used cell in a column, but not the first used cell.

Any help would be greatly appreciated.

Thanks.

[DP978]

Use

=MATCH("",A:A,-1)

to find the first cell with a non null entry

[sotiris5000]

Wow, thanks mate. That was really quick.
I should be able to combine that in the named range reference with an offset to find the end of the data series too, right?

Thanks again for your help.

Edit - sorry, nbvc, didn't see your post. Will try it out when I get to work tomorrow morning.

Many thanks.

[NBVC]

Use

=MATCH("",A:A,-1)

to find the first cell with a non null entry

that finds me the last row where text exists...

[sotiris5000]

Hello,

Just used NBVC's method and it works an absolute treat.
Thank you very much, you have saved me so much stress.

[NBVC]

Something like:

=OFFSET(INDEX($L:$L,MATCH(REPT("Z",255),$L:$L)-COUNTA($L:$L)+1),0,0,COUNTA($L:$L),1)

if your named range is within Column L and the items are text

or

=OFFSET(INDEX($L:$L,MATCH(9.999999E+307,$L:$L)-COUNTA($L:$L)+1),0,0,COUNTA($L:$L),1)

if items are numeric