Question for use of offset and range:Dynamic names

Dynamic names just don't show in the names box I am afraid.

To assign a range, try

=OFFSET($A$1,,,COUNTA($A:$A))

assuming the data is in clumn A

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Demi" <Demi@discussions.microsoft.com> wrote in message
news:D9DDFD1F-0258-46AE-A878-9455007C1343@microsoft.com...
> I have a set of data that i have assigned a range name.
> Time to time i keep adding data to this sheet.
> I know I can do it using Offset function. But the problem is I am not
really
> able to understand the Offset function. It does not include the new data i
> add in the range .
> And somehow after I write the offset function the range name does not show
> up in the upper right hand range name drop down menu.
> can someone kindly let me know how exactly can i use offset and why does
the
> range name disappear from teh drop down list after writing the offset
> function.
>
> thank you for all the help.
>
>

See this:

http://contextures.com/xlNames01.html#Dynamic

Also, only the names of static ranges will appear in the name box. When you
create a dynamic range, you're actually creating a named formula.

Biff

"Demi" <Demi@discussions.microsoft.com> wrote in message
news:D9DDFD1F-0258-46AE-A878-9455007C1343@microsoft.com...
>I have a set of data that i have assigned a range name.
> Time to time i keep adding data to this sheet.
> I know I can do it using Offset function. But the problem is I am not
> really
> able to understand the Offset function. It does not include the new data i
> add in the range .
> And somehow after I write the offset function the range name does not show
> up in the upper right hand range name drop down menu.
> can someone kindly let me know how exactly can i use offset and why does
> the
> range name disappear from teh drop down list after writing the offset
> function.
>
> thank you for all the help.
>
>

What is the current range you want to assign a name and what kind of
data does the range house? And, are you on Excel 2003?

Demi wrote:
> I have a set of data that i have assigned a range name.
> Time to time i keep adding data to this sheet.
> I know I can do it using Offset function. But the problem is I am not really
> able to understand the Offset function. It does not include the new data i
> add in the range .
> And somehow after I write the offset function the range name does not show
> up in the upper right hand range name drop down menu.
> can someone kindly let me know how exactly can i use offset and why does the
> range name disappear from teh drop down list after writing the offset
> function.
>
> thank you for all the help.
>
>

I have a set of data that i have assigned a range name.
Time to time i keep adding data to this sheet.
I know I can do it using Offset function. But the problem is I am not really
able to understand the Offset function. It does not include the new data i
add in the range .
And somehow after I write the offset function the range name does not show
up in the upper right hand range name drop down menu.
can someone kindly let me know how exactly can i use offset and why does the
range name disappear from teh drop down list after writing the offset
function.

thank you for all the help.

Dynamic names just don't show in the names box I am afraid.

To assign a range, try

=OFFSET($A$1,,,COUNTA($A:$A))

assuming the data is in clumn A

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Demi" <Demi@discussions.microsoft.com> wrote in message
news:D9DDFD1F-0258-46AE-A878-9455007C1343@microsoft.com...
> I have a set of data that i have assigned a range name.
> Time to time i keep adding data to this sheet.
> I know I can do it using Offset function. But the problem is I am not
really
> able to understand the Offset function. It does not include the new data i
> add in the range .
> And somehow after I write the offset function the range name does not show
> up in the upper right hand range name drop down menu.
> can someone kindly let me know how exactly can i use offset and why does
the
> range name disappear from teh drop down list after writing the offset
> function.
>
> thank you for all the help.
>
>

See this:

http://contextures.com/xlNames01.html#Dynamic

Also, only the names of static ranges will appear in the name box. When you
create a dynamic range, you're actually creating a named formula.

Biff

"Demi" <Demi@discussions.microsoft.com> wrote in message
news:D9DDFD1F-0258-46AE-A878-9455007C1343@microsoft.com...
>I have a set of data that i have assigned a range name.
> Time to time i keep adding data to this sheet.
> I know I can do it using Offset function. But the problem is I am not
> really
> able to understand the Offset function. It does not include the new data i
> add in the range .
> And somehow after I write the offset function the range name does not show
> up in the upper right hand range name drop down menu.
> can someone kindly let me know how exactly can i use offset and why does
> the
> range name disappear from teh drop down list after writing the offset
> function.
>
> thank you for all the help.
>
>

What is the current range you want to assign a name and what kind of
data does the range house? And, are you on Excel 2003?

Demi wrote:
> I have a set of data that i have assigned a range name.
> Time to time i keep adding data to this sheet.
> I know I can do it using Offset function. But the problem is I am not really
> able to understand the Offset function. It does not include the new data i
> add in the range .
> And somehow after I write the offset function the range name does not show
> up in the upper right hand range name drop down menu.
> can someone kindly let me know how exactly can i use offset and why does the
> range name disappear from teh drop down list after writing the offset
> function.
>
> thank you for all the help.
>
>