Thats where I went wrong.
The original formula was just a very simple example, I wanted to suggest
that the next version of Excel needed the ability to "learn" and replicate
formulas given a couple/series of examples. Ended up posting a question
instead of suggestion.
Apologies and Thanks Paul
"David McRitchie" wrote:
Hi Paul (and Ardus),
The last suggestion was referring to the cell one down from what was asked, this would work
B2: =OFFSET(A$4,(ROW(B2)-2)*3,0)
BTW, you marked the original post as a suggestion to Microsoft, witnout a suggestion.
and in fact asked a question instead.
---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
"Ardus Petus" wrote l...
Oooops!
in B2:
=OFFSET(A$2,(ROW()-1)*3,0)
--
AP
"Paul Moles" a écrit dans le message
B2 =A4, B3=A7, B4=A10 etc.
I would like to be able to drag this series down column B.