Can you use the MAX function in Excel to find the largest value across all worksheets? You can use a 3-D Reference or a spearing formula. In this episode, I will show you an easier way to create 3D Continue reading “Excel MAX Across All Worksheets – 2434”
Category: Excel
INDEX & XMATCH functions to spill a Two-Way Lookup Formula. Excel Magic Trick 1760 Part 2.
Learn how to create an advanced array formula to spill two-way lookup results using INDEX and MATCH function.
Topics:
1. (00:00) Introduction.
2. (00:14) Formula
3. (02:03) Thanks to Excel Lambda for this formula!
VLOOKUP, MAP & LAMBDA functions to spill a Two-Way Lookup Formula Excel Magic Trick 1760
Download Excel File: https://excelisfun.net/files/EMT1760.xlsx
Learn how to create an advanced array formula to spill two-way lookup results using VLOOKUP, MAP, LAMBDA and XMATCH Microsoft 365 functions. As of Monday, October 11, 2021, the MAP function is only in Continue reading “VLOOKUP, MAP & LAMBDA functions to spill a Two-Way Lookup Formula Excel Magic Trick 1760”
Sunday Oct 10, 2021 Old Guy BMX Park Fun at Lower Woodland BMX Park
Mike “Magic” Girvin (excelisfun at YouTube) and Nick “Rad 67” Roth get rad at Greenlake BMX Skatepark on Sunday Oct10, 2021. No big tricks, just Old Guy BMX fun!
Nick and I jump from bowl to bowl for first time. It Continue reading “Sunday Oct 10, 2021 Old Guy BMX Park Fun at Lower Woodland BMX Park”
Excel Add A Blank Row After Each Subtotal – 2433
Your manager asks if you can add a blank row after each subtotal. Episode 2433 shows you how to do this in Excel.
The first way, is clearly cheating: Increase the height of each row.
But the second way is the Continue reading “Excel Add A Blank Row After Each Subtotal – 2433”
Excel Add Subtotals To Only One Category – 2432
Geert asks: “in my experience the datasets are non-uniform in the sense that only a subpart of the data needs subtotals. (categories of data are sequentially listed and only 1 category has a further breakdown that needs subtotals – the Continue reading “Excel Add Subtotals To Only One Category – 2432”
VLOOKUP or XLOOKUP for Currency Conversion in Excel Formula? Excel Magic Trick 1758
Download Excel File: https://excelisfun.net/files/EMT1758.xlsx
Learn how to create a formula to convert a source currency amount into a target currency amount using a two-way lookup conversion lookup table. Learn five different formulas:
(00:00) Currency Conversion Introduction
1. (00:26) Do Continue reading “VLOOKUP or XLOOKUP for Currency Conversion in Excel Formula? Excel Magic Trick 1758”
Excel Removing Subtotals – 2431
A co-worker sent you a file with subtotals. How do you get rid of them?
Why are there 3 numbered buttons to the left of column A in Excel?
Why are there minus buttons and vertical lines to the left of column Continue reading “Excel Removing Subtotals – 2431”
Excel Subtotals Are Awesome – 2428
Accountants love the subtotals feature in Excel. We love to see details but add a little summary information. I have a lot of friends who think Subtotals should be deprecated and that anytime you use subtotals, you should be using Continue reading “Excel Subtotals Are Awesome – 2428”
Easy Frequency Distribution For Bingo Numbers in Excel – 2430
Candace is using a third-party Bingo app to generate numbers for a bingo game. Some people are complaining that the app is not fair and that it is calling some numbers too frequently. Candace manually keyed the numbers into Excel Continue reading “Easy Frequency Distribution For Bingo Numbers in Excel – 2430”
Minute by Minute Stock Price Arrows In Excel – 2429
Broadway Gypsy asks if there is a way to create a “minute by minute changing up/down stock price arrow in Excel”?
In this video, Bill shows how to use Icon Sets and the SIGN function to add up/down arrows next to Continue reading “Minute by Minute Stock Price Arrows In Excel – 2429”