Main Profile

At A Glance

Excel Magic Trick 920: Rotating List & Upside down VLOOKUP: Alternative Formulas

Download workbook: http://people.highline.edu/mgirvin/ExcelIsFun.htmstraighttovideo503 and ElibreBelgium at YouTube provide different Formulas For:Excel Magic Trick 917: Rotating List With Formula (For Little League Baseball Batting Order)Excel Magic Trick 918: Upside down VLOOKUP: Sort Decending & Bump Into First Smallest ValueSee how to:1. 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 with INDEX, MOD amd ROWS Functions.2. See how to Do a lookup that finds the smallest value that is greater than or equal to lookup_value using the INDEX, MATCH and COUNTIFS functions when the table must be sorted in ascending order (smallest to biggest)
Length: 08:52

Contact

Questions about Excel Magic Trick 920: Rotating List & Upside down VLOOKUP: Alternative Formulas

Want more info about Excel Magic Trick 920: Rotating List & Upside down VLOOKUP: Alternative Formulas? Get free advice from education experts and Noodle community members.

  • Answer

Ask a New Question