Prev: cell is blank then dont count range
Next: Combine two columns and delete original
From: Pontus on 4 Jul 2008 13:00
Hi,

I want to have a formula that retrievs the index from the cell to the right
of the cell with the formula.

I know that the formula below gives the index of the cell you are in but
that doesn't help me much unfortunately. Is there a simplier way or maybe a
way that utilises this code?

=SUBSTITUTE(SUBSTITUTE(CELL("address");"$";"");ROW();"")

Best Regards
Pontus
From: JMay on 4 Jul 2008 13:36
Do you mean:
A1 =Offset($B1,0,1)
B1 = Sum(A2:A4)
C1 = whatever

"Pontus" wrote:

> Hi,
>
> I want to have a formula that retrievs the index from the cell to the right
> of the cell with the formula.
>
> I know that the formula below gives the index of the cell you are in but
> that doesn't help me much unfortunately. Is there a simplier way or maybe a
> way that utilises this code?
>
> =SUBSTITUTE(SUBSTITUTE(CELL("address");"$";"");ROW();"")
>
> Best Regards
> Pontus
From: Pontus on 4 Jul 2008 14:34
Hmm, I'll try to explain better.

What I want to do is to have a formula that I can copy in to any cell which
will give the cell index of the cell to the right.

Exampel:
If I copy my formula in to cell K23 I want the answer to be L23 or
If I copy my formula in to cell B23 I want the answer to be C23 etc.

Hope I made myself more clear now =)

Thanks for answering.
Pontus

"JMay" wrote:

> Do you mean:
> A1 =Offset($B1,0,1)
> B1 = Sum(A2:A4)
> C1 = whatever
>
> "Pontus" wrote:
>
> > Hi,
> >
> > I want to have a formula that retrievs the index from the cell to the right
> > of the cell with the formula.
> >
> > I know that the formula below gives the index of the cell you are in but
> > that doesn't help me much unfortunately. Is there a simplier way or maybe a
> > way that utilises this code?
> >
> > =SUBSTITUTE(SUBSTITUTE(CELL("address");"$";"");ROW();"")
> >
> > Best Regards
> > Pontus
From: Ragdyer on 4 Jul 2008 14:54
Would you care to elaborate on what you intend to do with that address of
the cell on the right?

The reason I'm asking, is because you can use a "relative" named formula
that can return the *contents* of that cell to the right of which ever cell
you enter it into.

Would that be of interest to you?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Pontus" <Pontus(a)discussions.microsoft.com> wrote in message
news:7DC46E30-CC1E-4339-B79C-C19BE87CD39C(a)microsoft.com...
> Hmm, I'll try to explain better.
>
> What I want to do is to have a formula that I can copy in to any cell
which
> will give the cell index of the cell to the right.
>
> Exampel:
> If I copy my formula in to cell K23 I want the answer to be L23 or
> If I copy my formula in to cell B23 I want the answer to be C23 etc.
>
> Hope I made myself more clear now =)
>
> Thanks for answering.
> Pontus
>
> "JMay" wrote:
>
> > Do you mean:
> > A1 =Offset($B1,0,1)
> > B1 = Sum(A2:A4)
> > C1 = whatever
> >
> > "Pontus" wrote:
> >
> > > Hi,
> > >
> > > I want to have a formula that retrievs the index from the cell to the
right
> > > of the cell with the formula.
> > >
> > > I know that the formula below gives the index of the cell you are in
but
> > > that doesn't help me much unfortunately. Is there a simplier way or
maybe a
> > > way that utilises this code?
> > >
> > > =SUBSTITUTE(SUBSTITUTE(CELL("address");"$";"");ROW();"")
> > >
> > > Best Regards
> > > Pontus

From: b&s on 4 Jul 2008 15:21
"Pontus" <Pontus(a)discussions.microsoft.com> wrote in message
news:7DC46E30-CC1E-4339-B79C-C19BE87CD39C(a)microsoft.com
> Hmm, I'll try to explain better.
>
> What I want to do is to have a formula that I can copy in to any cell
> which will give the cell index of the cell to the right.
>
> Exampel:
> If I copy my formula in to cell K23 I want the answer to be L23 or
> If I copy my formula in to cell B23 I want the answer to be C23 etc.
>
> Hope I made myself more clear now =)
>
> Thanks for answering.
> Pontus
>

.... maybe: =ADDRESS(ROW();COLUMN()+1)

--
pozdrav!
Berislav
 |  Next  |  Last
Pages: 1 2 3 4 5
Prev: cell is blank then dont count range
Next: Combine two columns and delete original