### Excel Magic Trick 917: Rotating List With Formula (For Little League Baseball Batting Order)

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htmSee how to Type the starting number position for a list, such as 3, and have the formula show the records starting at 3, then going to the end, and once it hits the end, it starts at the top again. A rotating List:1. See the functions: ROWS, COUNTA, IF and INDEX to create a lookup formula that will extract names from a list that start at a given position, display all the names until the end of the list, and then start back at the beginning at the first record or name.2. Example in this video shows how to automatically get a different Little League Baseball Batting Order with a different Leadoff Hitter for each game using a formula.

Length:
06:58