Download Excel Start File: [ Ссылка ]

Download workbook: [ Ссылка ]
See 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.

свернуть