"Earl Kiosterud" <someone@nowhere.com> wrote
....
> Put this in A31, and copy down.
> =OFFSET(A31,-(INT((ROW()-1)/30))*30,INT((ROW()-1)/30),1,1)

Much neater, Earl !

Perhaps with just a typo corrected, in A31, copied down to A1530:
=OFFSET(A31,-(INT((ROW()-1)/30))*30,INT((ROW()-1)/30)-1,1,1)

--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--