Main Profile

At A Glance

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

Contact

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

Want more info about Excel Magic Trick 917: Rotating List With Formula (For Little League Baseball Batting Order)? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question