Incremental Numbering whitin a formula
Here's the next part of the puzzle Cell I2:
=IF(Sheet3!A2=Sheet3!A1,Sheet3!E3,Sheet3!E3)
Cell I3:
=IF(Sheet3!A5=Sheet3!A4,Sheet3!E6,Sheet3!E6)
the cell wich the data is fetched from, eg. Sheet3!E3 has to increase be
increments of 3
"Gary''s Student" wrote:
In A2 enter:
=INDIRECT("Sheet3!A"&3*ROW()-4)
and copy down
--
Gary''s Student - gsnu200754
"The Ron" wrote:
I need to exctract data from another sheet but I need to do it for every
third cell.
My formula so far cell A2: =Sheet3!A2
cell A3: =Sheet3!A5
cell A4: =Sheet3!A8
etc.
How can I copy this down with the cells as it's not copying down correctly
at the moment?
|