Formula to reference every second row
"MartinW" wrote:
Hi Neville,
You dont say what your formula is but this may be of some help.
This formula placed in Sheet2 and dragged down will return
every second value from column A in Sheet1.
=OFFSET(Sheet1!A$1,(ROWS($1:1)-1)*2,,)
HTH
Martin
"Neville Bailey" wrote in message
...
I have created a formula to reference a cell in another workbook. I now
want
to copy the formula down a number of consecutive rows, but I want it to
reference the cell in every second row in the other workbook.
How can I do that?
Brilliant! Thanks MartinW, it works like a charm!
|