Prev: sorting data
Next: data not carrying over from access to excel
From: quinxorin on 25 Mar 2010 14:56
Thanks. I tried all sorts of symbols, like single quotes, double quotes, and
paentheses, but I never thought to try the dollar sign.

"David Biddulph" wrote:

> A suitable topic to type into Excel help is "relative & absolute addressing"
> The dollar sign in a reference makes the row, or column, absolute.
> --
> David Biddulph
>
>
> "quinxorin" <quinxorin(a)discussions.microsoft.com> wrote in message
> news:D718CEE8-BDB0-4BBB-8185-48B8CD575317(a)microsoft.com...
> > I need to fill a formula in a range of cells downward, specifically the
> > formula IF(OR(O2=U1,P2=U1,Q2=U1),2-L2,0), with the U1 cell references
> > remaining the same, continuing to refer to U1, while the other cell
> > references (O2, P2, Q2, and L2) change and fill normally. Conversely, I
> > need
> > to be able to fill the formula right with U2 being the only reference that
> > changes. Is this possible to do? If so, how? Doing this manually would
> > take
> > several hours. I am using Excel 2007.
>
>
> .
>
 | 
Pages: 1
Prev: sorting data
Next: data not carrying over from access to excel