Formula Help

  • Thread starter Thread starter John Calder
  • Start date Start date
J

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
 
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.
Click to expand...

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
 
Back
Top