Re: Stop a formula from changing

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 11/23/04 

Date: Tue, 23 Nov 2004 12:49:52 +0100

Hi
if you have this formula in cell B1 you may try (not tested):
=OFFSET(B1,0,-1)
and copy this down 

--
Regards
Frank Kabel
Frankfurt, Germany
"Stuck for ideas" <Stuckforideas@discussions.microsoft.com> schrieb im
Newsbeitrag news:6E921554-DCF1-4B8F-8525-CE6FA65CFA7E@microsoft.com...
> Tried it and it worked (too well!). Now all I need to do, is try and
use the
> same formula across the row but not be identical to the first one.
> Thanks
>
> "Stuck for ideas" wrote:
>
> > Gotta go home will let you know tomorrow if it works.
> > Thanks
> >
> > "Frank Kabel" wrote:
> >
> > > Hi
> > > =INDIRECT("A1")
> > >
> > > --
> > > Regards
> > > Frank Kabel
> > > Frankfurt, Germany
> > >
> > > "Stuck for ideas" <Stuckforideas@discussions.microsoft.com>
schrieb im
> > > Newsbeitrag
news:ACE1F3E3-1956-461E-9E35-2E36E8D97432@microsoft.com...
> > > > 1. The formula in b1 is '=$a$1'
> > > > 2. I drag or cut & paste the value in 'a1' to 'a3'
> > > > 3. I want the formula in 'b1' to stay as '=$a$1' instead of
changing
> > > to
> > > > '=$a$3'
> > > >
> > > > "Frank Kabel" wrote:
> > > >
> > > > > Hi
> > > > > some questions:
> > > > > - how do you 'move' your data
> > > > > - please describe exactly:
> > > > >     -> what formula you're currently using (post this
formula)
> > > > >     -> how you want to move the formula
> > > > >     -> you expected result
> > > > >
> > > > > --
> > > > > Regards
> > > > > Frank Kabel
> > > > > Frankfurt, Germany
> > > > >
> > > > > "Stuck for ideas" <Stuckforideas@discussions.microsoft.com>
schrieb
> > > im
> > > > > Newsbeitrag
> > > news:79EB0A7A-7928-4F0C-8BA1-8BD71A81FFF3@microsoft.com...
> > > > > > That would work if i wanted to move 'b1', but, say the
formula in
> > > > > 'b1' is
> > > > > > =$a$1 and I move the data in 'a1' to 'a3' the formula in
'b1'
> > > changes
> > > > > to
> > > > > > =$a$3. I don't want that to happen.
> > > > > > But thanks anyway
> > > > > >
> > > > > > "Frank Kabel" wrote:
> > > > > >
> > > > > > > Hi
> > > > > > > use
> > > > > > > $A$1
> > > > > > >
> > > > > > > --
> > > > > > > Regards
> > > > > > > Frank Kabel
> > > > > > > Frankfurt, Germany
> > > > > > >
> > > > > > > "Stuck for ideas" <Stuck for
ideas@discussions.microsoft.com>
> > > > > schrieb
> > > > > > > im Newsbeitrag
> > > > > > >
news:95366174-69F5-4A50-91C9-46B117AF90C6@microsoft.com...
> > > > > > > > I have a spread*** where I want to move the data from
1
> > > cell to
> > > > > > > another.
> > > > > > > > But I don't want the formula to change.
> > > > > > > >
> > > > > > > > For example cell 'b1' refers to 'a1' i want to move the
data
> > > in
> > > > > cell
> > > > > > > 'a1' to
> > > > > > > > another cell but I want the formula in 'b1 to still
reference
> > > > > 'a1'
> > > > > > > not the
> > > > > > > > data that was in 'a1'.
> > > > > > > >
> > > > > > > > Any ideas
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > >
> > >