Download Excel File: http://excelisfun.net/files/Flip_A_Column_In_Excel_Duel_196.xlsx
Learn how to flip on column in Excel. See Microsoft 365 Excel formulas, Worksheet Formulas that work in any version of Excel, Spilled Array with Old School functions, Custom List and Secret Sort Trick, LAMBDA re-usable function and Power Query.
Topics:
1. (00:00) Duel Song.
2. (00:28) Mr Excel explains the problem at hand
3. (01:15) Mr Excel shows Microsoft 365 Excel formula using SORTBY & SEQUENCE
4. (02:03) Excelisfun explains Mr Excel’s formula
5. (02:36) Excelisfun creates Worksheet Formula that work in any version of Excel: INDEX, ROWS and a Contracting Range
6. (03:43) Excelisfun shows a Spilled Array with Old School functions: INDEX, ROWS and ROW.
7. (04:36) Error that leads to evidence of why the new Worksheet Formula Engine and Spilled Array Formulas are much mor efficient than the “Old School” Formulas
8. (05:14) Mr Excel explains Excelisfun formulas
9. (05:49) Mr Excel shows Custom List and Secret Sort Trick
10. (06:58) Excelisfun shows LAMBDA re-usable function to flip a column
11. (09:14) Mr Excel shows Power Query and hidden column trick
12. (10:38) Mr Excel Concludes and a bit of dueling music