Dear Mr. Earl and Max,

It worked fine.
You gentlemen are just great.
Thank you very much,
Jim

"Max" wrote:

"Earl Kiosterud" 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
--