reciprocal equation

**nz104** · 09-20-2008, 07:40 PM

I'm looking for an equation where i could expand down row 1 as needed that would equal the reciprocal of the excel sheet. example, b1=a2, c1=a3, d1=a4, e1=a5 so on and so forth. Anything that I can think of wouldn't work for easily for future expansion of the excel sheet.

Thanks in advanced for any advice.

**Paul** · 09-20-2008, 07:43 PM

Hi nz,

In A2 you could use:

=OFFSET($A$1,0,ROW(A1))

then fill that down as far as needed.

**martindwilson** · 09-20-2008, 07:54 PM

or if it's across the row
in b1 put =INDIRECT("A"&COLUMN()) and drag across

**nz104** · 09-20-2008, 10:07 PM

Thank you martindilson, exactly what i was looking for. Another question if you happen to see it, i'm trying to do the same thing with a row, but i tried to follow logic with =INDIRECT(ROW()&3) but it doesn't work properly.