Excel Forum
Similar Content
Quickly Combine a List of Values and Put a Delimiter Between Each Value in Excel
Tutorial: How to combine a list of data into one cell while putting a delimiter between each piece ...
Highlight and Sort the Top and Bottom Performers in a List in Excel
Tutorial: How to highlight the rows of the top and bottom performers in a list of data. This allow...
Find the Most Frequently Occurring Value in a List in Excel
Tutorial: Use a formula to return the most frequently occurring word or value from a range of cells...



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.