Loading...

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

34,739 views

Loading...

Loading...

Transcript

The interactive transcript could not be loaded.

Loading...

Loading...

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.

  • Category

  • License

    • Standard YouTube License

Loading...

Advertisement
to add this to Watch Later

Add to

Loading playlists...