Thread
:
nonsequential cell references
View Single Post
#
3
Ron Coderre
Posts: n/a
Actually, this also works:
=OFFSET(Sheet2$A$1,ROW(A1)/2,0)
(Enter formula in Sheet1!A1 and copy to A3, A4, etc)
--
Regards,
Ron
Reply With Quote