Try this:
On Sheet 1
A6: =INDEX(Sheet2!$A:$A,MAX((ROW(A6)-6)*11,1),0)
Copy that formula down as needed.
Does that help?
--
Regards,
Ron
"bruner" wrote:
> I have a list of names on sheet 2 of a worksheet that extends from A1 to
> A249. I want to return name 1 on sheet 1 in A6, name 2 in A17, name 3 in
> A28, etc. What formula can I use to do this?
>
> I figured out how to do it with offset when i'm copying and pasting for each
> line (A1, A2, A3, A4, etc.), but not for every 11 rows without it skipping to
> the 11th name on the list? Any suggestions?
Bookmarks