Hi,
You may also use this approach (no formulas)
In another sheet, link A2:A5 to the range of names in column A of sheet 1.
In B2:B5, enter 1,2,3,4. In B6:B9, enter 1,2,3,4. In A1 and B1 type Names
and Nos. Now highlight A1:B5 and sort on column B. This will insert a
blank row after each entry. Now highlight C5:C12 and press Ctrl+G Special
Blanks. Now press = up arrow key Ctrl+Enter
Hope this helps.
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"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.