named dynamic range that ends with first text entry
 

I've found many example on how to created a dynamic named range which ends at
the last numeric or text entry. I would like to create one that ends at the
first text entry.

The data I'm workign with has a heading, then numeric data, then another
heading, then more numeric data. I only need the numeric data between the
first heading and the second, and the amount of rows between frequently
changes.

Is this possible?

Thank you, super-geniuses.

named dynamic range that ends with first text entry
 

Hi!

One way:

Assume your first header is in A1 followed by several rows of numbers and
then another header.

=OFFSET(A2,,,MATCH("*",A2:A100,0))

Biff

"mcmanusb" wrote in message
...
I've found many example on how to created a dynamic named range which ends
at
the last numeric or text entry. I would like to create one that ends at
the
first text entry.

The data I'm workign with has a heading, then numeric data, then another
heading, then more numeric data. I only need the numeric data between the
first heading and the second, and the amount of rows between frequently
changes.

Is this possible?

Thank you, super-geniuses.

named dynamic range that ends with first text entry
 

Depending on how you intend to use this range you might want to use this
instead:

=OFFSET(A2,,,MATCH("*",A2:A100,0)-1)

Biff

"Biff" wrote in message
...
Hi!

One way:

Assume your first header is in A1 followed by several rows of numbers and
then another header.

=OFFSET(A2,,,MATCH("*",A2:A100,0))

Biff

"mcmanusb" wrote in message
...
I've found many example on how to created a dynamic named range which
ends at
the last numeric or text entry. I would like to create one that ends at
the
first text entry.

The data I'm workign with has a heading, then numeric data, then another
heading, then more numeric data. I only need the numeric data between
the
first heading and the second, and the amount of rows between frequently
changes.

Is this possible?

Thank you, super-geniuses.

named dynamic range that ends with first text entry
 

Perfect. Thank you!

"Biff" wrote:

Depending on how you intend to use this range you might want to use this
instead:

=OFFSET(A2,,,MATCH("*",A2:A100,0)-1)

Biff

"Biff" wrote in message
...
Hi!

One way:

Assume your first header is in A1 followed by several rows of numbers and
then another header.

=OFFSET(A2,,,MATCH("*",A2:A100,0))

Biff

"mcmanusb" wrote in message
...
I've found many example on how to created a dynamic named range which
ends at
the last numeric or text entry. I would like to create one that ends at
the
first text entry.

The data I'm workign with has a heading, then numeric data, then another
heading, then more numeric data. I only need the numeric data between
the
first heading and the second, and the amount of rows between frequently
changes.

Is this possible?

Thank you, super-geniuses.

named dynamic range that ends with first text entry
 

You're welcome. Thanks for the feedback!

Biff

"mcmanusb" wrote in message
...
Perfect. Thank you!

"Biff" wrote:

Depending on how you intend to use this range you might want to use this
instead:

=OFFSET(A2,,,MATCH("*",A2:A100,0)-1)

Biff

"Biff" wrote in message
...
Hi!

One way:

Assume your first header is in A1 followed by several rows of numbers
and
then another header.

=OFFSET(A2,,,MATCH("*",A2:A100,0))

Biff

"mcmanusb" wrote in message
...
I've found many example on how to created a dynamic named range which
ends at
the last numeric or text entry. I would like to create one that ends
at
the
first text entry.

The data I'm workign with has a heading, then numeric data, then
another
heading, then more numeric data. I only need the numeric data between
the
first heading and the second, and the amount of rows between
frequently
changes.

Is this possible?

Thank you, super-geniuses.

named dynamic range that ends with first text entry
 

Biff - FWIW,

"*" includes nulls ( "" - zero length strings) in it's match criteria in
addition to "Text".
"*?" will look at *only* "Text" (alpha or numeric).
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Biff" wrote in message
...
You're welcome. Thanks for the feedback!

Biff

"mcmanusb" wrote in message
...
Perfect. Thank you!

"Biff" wrote:

Depending on how you intend to use this range you might want to use
this
instead:

=OFFSET(A2,,,MATCH("*",A2:A100,0)-1)

Biff

"Biff" wrote in message
...
Hi!

One way:

Assume your first header is in A1 followed by several rows of numbers
and
then another header.

=OFFSET(A2,,,MATCH("*",A2:A100,0))

Biff

"mcmanusb" wrote in message
...
I've found many example on how to created a dynamic named range
which
ends at
the last numeric or text entry. I would like to create one that
ends
at
the
first text entry.

The data I'm workign with has a heading, then numeric data, then
another
heading, then more numeric data. I only need the numeric data
between
the
first heading and the second, and the amount of rows between
frequently
changes.

Is this possible?

Thank you, super-geniuses.