Repet a names 3 times

[XLalbania]

Hello Excel Gurus
As you can see from the screen shot, i need to repet a name 3 times in a range
please no VBA
Thank you so much

	A	B	C
1	Name		List *3 times
2	Luis		Luis
3	Frank		Luis
4	Mike		Luis
5	Anna		Frank
6			Frank
7			Frank
8			Mike
9			Mike
10			Mike
11			Anna
12			Anna
13			Anna

[zbor]

Here:

Please Login or Register  to view this content.

Write 3 in B1 and that way you can be flexibile and change repeating times as you want.

If you don't want this and use only 3 then:

Please Login or Register  to view this content.

[Phuocam]

Or ...

=INDEX($A$2:$A$1000,ROWS(C$1:C3)/3)

[XLalbania]

Thank you zbor
Now I dont have a PC i will let you know, anyway since Im studing Excel do you know another approch of formula
THANK YOU