Formula Help

[John Calder]

Hi

I run Excel 2K.

I have one column and 500 rows of data on one sheet. On another sheet I
want to have a formula that is in every 3rd row which reads each of the
entries in the first sheet.

I can do this manually of course, however when I try to copy it down the
sheet the cell references are all wrong because I am jumping 3 rows at a
time. Is there a formula that will allow me just to copy it down in 3 cell
increments but have it refer to the sequential cells in the 1st sheet.


Thanks

 

[Ed Ferrero]

Hi John,

Is there a formula that will allow me just to copy it down in 3 cell
increments but have it refer to the sequential cells in the 1st sheet.

You can try;
=INDIRECT(ADDRESS(1+ROW()/3,1,,,"Sheet2"))

Copy it in a cell in row 1, it will return the value in cell A1 in Sheet2

Copy to row 4, returns value in cell A2 in Sheet2

To change the returned cell reference, change the '1's in the formula

Ed Ferrero
www.edferrero.com