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, Sort, and Group 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 allows...
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 VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.