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.