Thank you!!!! It worked but one other ?. What if the list of names on Sheet1
begins on row 8 intead of row 2. How would I adjust the formulas to begin
looking on a specified row?

"Jacob Skaria" wrote:

Sheet2 A1. copy the below formula down..

=INDIRECT("Sheet1!A" &ROUNDUP(ROW()/2,0),TRUE)


If this post helps click Yes
---------------
Jacob Skaria


"GoBucks" wrote:

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.