PDA

View Full Version : Solved: Get cell reference from one cell



grichey
06-04-2009, 01:39 PM
I'm not even sure what the terminology is here but here's what I'm trying to do.

Say I have the following in C1:=A1, in C2, I want C2:=A3. I am trying to figure out if it's possible to grab the formula out of C1 and just do + 2 to make C2 ref A3.

Thoughts?

mdmackillop
06-04-2009, 02:12 PM
Hi Gavin,
Are you looking to copy down to extend the formulae? I'm not clear on the purpose, so unclear on the solution.

grichey
06-04-2009, 02:15 PM
Work around:
C1: =IF([CRITERIA],A1,"")

fill down, then just ran a sort to get rid of the zeros.

grichey
06-04-2009, 02:17 PM
What I am trying to do is put the formula say =A1 in cell C1, in cell C2, I would like it to reflect the data in A3. so for each step down once in column c, the data linked to A drops by 2 cells.

Does that make sense?

ex
A1: Z
A2 : X
A3: Y

Column C should read (by using = a formula to column A)
C1:Z
C2: Y

mdmackillop
06-04-2009, 02:41 PM
in C1 and copy down =OFFSET(A$1,ROW()*2-2,0,1,1)

grichey
06-04-2009, 02:46 PM
thanks... I need to get better @ the using of offset