Increment a formula by row and column?

[mitchellsm]

I am trying to create a formula that will allow me to refer to the cell one below and one right of the column previously referenced (basically data in a diagonal line) in a new sheet in that workbook. Any help is appreciated--thanks!

Here's a simplified version of what I'm trying to do:

Sheet 1

275	55	333	418
21	153	4444	375
1976	400	20	1
77	52	96	4599

<tbody>
</tbody>

Sheet 2

275

153

20

4599

<tbody>
</tbody>

 

[JoeMo]

Assuming the first data point on sheet1 is in cell A1, then in cell A1 on sheet2 enter:
=OFFSET(Sheet1!$A$1,ROW(A1)-1,ROW(A1)-1)
and copy down.

 

[mitchellsm]

Thank you!!

 

[JoeMo]

Thank you!!

You are welcome - thanks for the reply.