multiple column dynamic range
Dave,
I clicked F5 and then i noticed the the list range plus the addition of
the C and D cell below list was surrounded by a black bold border. Thank you
again.
"Dave Peterson" wrote:
The formula works perfectly for me.
I don't have any other guesses why it's not working for you.
But you didn't really answer my question about any typos in the worksheet name.
Try changing the worksheet name to A (a single character).
Then check the name to see what it refers to. Excel is smart enough to adjust
it to:
=OFFSET(A!$C$2,0,0,COUNTA(A!$C:$C),2)
If you don't see that new formula, then the name of the worksheet isn't
"Measure". There's a typo somewhere.
Robin wrote:
Dave this is the formula that I was given to use
=OFFSET(Measure!$C$2,0,0,COUNTA(Measure!$C:$C),2)
I want the initial cell to be C2 .
The initial row is C2 and D2 C2 is a list of words and D2 is a list of
corresponding abbreviations. I have typed the list to the cells C234 and
D234. I would like the cells to extend equally for as long as is appropriate
I think 100 would cover any additions that they might have. for C2 and D2
thus allowing the user to type any additions that they might have. I know tha
the 2 added prior to the last parenthesis is due to updating the range of 2
columns.
Is it that the row range that needs to be changed to an additional 100 be
included in the formula?
I also have the Measure sheet selected when I am updating the formula.
Does the Scope selection have any thing to do with this?
Concerning this legal stuff is there something I need to change in the
formula.
You have helped me for a long time and I thank you.
Robin.
"Dave Peterson" wrote:
If your formula evaluated to use start in Row 1 but extend the range to 12 rows,
that would be legal.
But if that formula evaluated to start in row 1 but extend for 0 or a negative
number of rows, then that would not be legal.
Are you sure that the worksheet is named Measure?
Maybe there's a spelling error (or an extra space character at either end???
Robin wrote:
C1:D1 is a topic
Cells C ARE words andCells D are abbreviations. I do not know what a legal
range reference.
"Dave Peterson" wrote:
What's in column C?
If there's not enough to count, then you may not have a legal range/reference.
ps. If you're not sure what's in C1 all the time, you may want to use a formula
like:
=OFFSET(Measure!$C$2,0,0,COUNTA(Measure!$C:$C)-COUNTA(Measure!$C$1),2)
Then the range (if it's legal!) will start in row 2.
Robin wrote:
I have a range from C2:D234. The column C has a heading of term and Column D
is the abbreviaton. I want the cells starting wiht C235 and D 235 to be able
to have additions made by the user. I have been given instructions to do the
following
have 2007 version and I have gone to Formulas tab and then select name
define
Then I type in DynAbbrMeasure
I select list (is there something else that I should select?)
I then Paste =OFFSET(Measure!$C$2,0,0,COUNTA(Measure!$C:$C),2)
Click ok
Press F5
In the go to box it states D236:D236
I type in DynAbbrMeasure
It states that the Reference is not valid
What am I doing wrong? The end of the typed list is C 234 & D 234 and I
would like the range to be added to and an indefinite range. I would
appreciate your help with this.
Sincerely,
Robin
--
Dave Peterson
--
Dave Peterson
--
Dave Peterson
|