Dear Mr. Earl and Max,

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

"Max" wrote:

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