Reverse A Column In Excel – With Mike Girvin – Duel 196

You have a column of data in Excel. You need to reverse the column, bottom to top.
How can you do this? Can you do it without a helper column?
Bill Jelen and Mike Girvin compare six ways

Table of Contents
(0:00) Description Continue reading “Reverse A Column In Excel – With Mike Girvin – Duel 196”

Flip Column in Excel? Formula, Sort, Power Query or LAMBDA? Dueling Excel #196 Mr Excel & Excelisfun

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, Continue reading “Flip Column in Excel? Formula, Sort, Power Query or LAMBDA? Dueling Excel #196 Mr Excel & Excelisfun”

Find The Last One In A Series Of 1s And Zeroes With Dan Mayoh – 2445

There is a classic Financial Modeling problem in Excel. You are checking values in each month and you end up with a row of zero and one values. How can you find the last month where you have a one?
Dan Continue reading “Find The Last One In A Series Of 1s And Zeroes With Dan Mayoh – 2445”

Excel Formula to Convert Horizontal Labels to Vertical Numbered List: TRANSPOSE or INDEX? EMT 1765

Download Excel File: https://excelisfun.net/files/EMT1765.xlsx
Learn how to convert a horizontal range of labels to a vertical numbered list of labels. Learn how to do it with a formula in Microsoft 365 Excel and an “Old School” method that Continue reading “Excel Formula to Convert Horizontal Labels to Vertical Numbered List: TRANSPOSE or INDEX? EMT 1765”

Excel Statistical Analysis 04: PivotTable & Power Query to Build Frequency Distributions

ESA #4: PivotTable Grouping to Build Frequency Distributions & Power Query to Import CSV Data
Download Excel File: https://excelisfun.net/files/Ch01-ESA.xlsm
Download CSV File: https://excelisfun.net/files/Ch01-ESA-AutoData.csv
Learn about how to use Power Query to import and transform CSV File data Continue reading “Excel Statistical Analysis 04: PivotTable & Power Query to Build Frequency Distributions”

Excel Search In Reverse (Jenny) – feat. Tommy Tutone – 2444

How can you reverse text in Excel? There is not a REVERSE function. You’ve recently seen me do this with a VBA loop. Lianna Gerrish from the Financial Modeling World Cup Semi-Finals would flip it and reverse it with strREVERSE Continue reading “Excel Search In Reverse (Jenny) – feat. Tommy Tutone – 2444”

Excel Two Way Lookup Three Ways – 2443

Matching data between two Excel worksheets where you need to match both the city and the tax rate in order to find the match. This video shows three different methods.

Table of Contents
(0:00) Welcome
(1:01) Using XLOOKUP for two-way match
(2:15) Using VLOOKUP Continue reading “Excel Two Way Lookup Three Ways – 2443”

Excel Statistical Analysis 03: Comprehensive Worksheet Formula & Model Building Video

Download Excel File: https://excelisfun.net/files/Ch01-ESA.xlsm
Learn the fundamentals of Excel worksheet formulas, functions and how to build worksheet models.
Topics:
(00:00) Introduction
(00:19) Topics in video
(00:45) Worksheet Formula Elements: what can go into a formula
(01:57) Excel Formula Order of Operations
(03:23) Guidelines for Continue reading “Excel Statistical Analysis 03: Comprehensive Worksheet Formula & Model Building Video”

Excel Find Last Item In List Using MATCH But Not XMATCH – 2442

There are a pair of well known Excel tricks with MATCH:
Find the last item in a long list of items that might contain empty cells.
Find the only number in a range of Error or Text values.
Excel tricksters have made use Continue reading “Excel Find Last Item In List Using MATCH But Not XMATCH – 2442”

Excel Statistical Analysis 02: Structure of Excel files, Navigation, Keyboard and more

Download Excel File: https://excelisfun.net/files/Ch01-ESA.xlsm
Topics in video:
(00:00) Introduction
(00:15) Open Excel file using Windows Explorer
(00:46) Navigating through large Workbook File with many Sheet Tabs
(02:27) Structure of an Excel Worksheet and Workbook
(04:21) Conventions for Workbook files in this class
(06:09) Excel Continue reading “Excel Statistical Analysis 02: Structure of Excel files, Navigation, Keyboard and more”

Excel List All Lottery Combinations – 2441

Reid would like to list all 6-number combinations of the numbers 1 to 44. For example, 1-2-3-4-5-6, 1-2-3-4-5-7, and so on up to 39-40-41-42-43-44. The first thing to realize is that all lottery combinations are a lot of numbers. Over Continue reading “Excel List All Lottery Combinations – 2441”