Rating is available when the video has been rented.
This feature is not available right now. Please try again later.
Published on May 12, 2012
Download workbook: http://people.highline.edu/mgirvin/Ex... 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.