Try this:

Names in Sheet1 A1:An

Enter this formula on another sheet in cell A1 and copy down as needed:

=INDEX(Sheet1!A:A,CEILING(ROWS(A$1:A1)/2,1))

--
Biff
Microsoft Excel MVP


"GoBucks" wrote in message
...
I have a column in one worksheet (Col A) with a list of names:

Col A
Jones
Smith
Williams
James

In another worksheet I am looking for a formula that will allow me to list
the first name twice (Jones) and then go the next name in the list (Smith)
and list that twice; then list Williams twice, etc.

Column A
Jones
Jones
Smith
Smith
Williams
Williams
James
James

I am hoping that this can be done with INDIRECT somehow.