cell names in functions
 

Hi there,

cell names are great to identify the cells, but when used in a formula, I
can not drag them like normal cell references (ie: A1), they seem to be more
like th efixed type (ie $A$1), but I can not unlock those (F4 key does not
hold for these references), does anyone know the solution for this?

Obviously, I can select th ecell name in the formula, replace it with a
normal reference and drag this, but I think it is quite inconvenient...
Besides, after this, the formula keeps refering to a cell reference, not to a
cell name.

Thanks in advance,

Max

cell names in functions
 

Hi Max

The problem is that the name appears in the formula, and this isn't
incremented when you fill down. One potential alternative might be to
use a defined Formula (ie you name a formula to refer to a cell
relative to the one contaning the formula) - for instance:

=OFFSET(INDIRECT("RC",FALSE),0,-1)

which will point to the cell to the immediate left of the one in which
the formula resides (no matter which sheet it is on) - you can name it
more or less what you like - say myFormula, and then use it in your
Excel sheet:

=myFormula

You can then copy this down (and incorporate into more complicated
formulae).

Hope this helps!

Richard

..





On 19 Feb, 07:52, Max wrote:
Hi there,

cell names are great to identify the cells, but when used in a formula, I
can not drag them like normal cell references (ie: A1), they seem to be more
like th efixed type (ie $A$1), but I can not unlock those (F4 key does not
hold for these references), does anyone know the solution for this?

Obviously, I can select th ecell name in the formula, replace it with a
normal reference and drag this, but I think it is quite inconvenient...
Besides, after this, the formula keeps refering to a cell reference, not to a
cell name.

Thanks in advance,

Max

cell names in functions
 

If you make the name refer to a range of cells, and refer to that name in a
formula, such as =Bob*12, the fist item picks up the first value in the
range, the second the next, etc.

It is limited in where the names are defined (row relationship), but it does
work.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Max" wrote in message
...
Hi there,

cell names are great to identify the cells, but when used in a formula, I
can not drag them like normal cell references (ie: A1), they seem to be
more
like th efixed type (ie $A$1), but I can not unlock those (F4 key does not
hold for these references), does anyone know the solution for this?

Obviously, I can select th ecell name in the formula, replace it with a
normal reference and drag this, but I think it is quite inconvenient...
Besides, after this, the formula keeps refering to a cell reference, not
to a
cell name.

Thanks in advance,

Max