Excel Forum



Excel Magic Trick 493: Repeat a List of Names 7 times


See how to use 1) Copy, Paste and Sort and 2) an INDEX formula using MOD and ROWS functions to repeat list of names 7 times. See how to increment numbers in a formula 1 to 11, 1 to 11, etc. using MOD and ROWS functions.





Got a Question? Ask it Here in the Forum.