“My spreadsheet must be haunted” is a great opening line to an Excel question sent in just before Halloween. You have 1510 rows in Excel. You try to Delete Sheet Rows from A1511 to A1048576, but the rows keep coming Continue reading “How To Delete Blank Rows At Bottom Of Excel – 2436”
Category: Excel
Arrays As Arguments To Application WorksheetFunction in Excel VBA – 2435
How to use XMATCH with Application . WorksheetFunction in Excel VBA? Today, a question from Hydrogen Peroxide. How can you refer to an array inside of a formula in Excel VBA.
This workbook takes a look at how to simulate Continue reading “Arrays As Arguments To Application WorksheetFunction in Excel VBA – 2435”
Excel XNPV Function: Discounting non-Periodic Cash Flows. Algorithm for How it Works! EMT 1761
Download Excel File: https://excelisfun.net/files/EMT1761.xlsx
Learn how to use the XNPV function to discount non-periodic future cash flows to value investments.
This video answers the question: why does the NPV and XNPV function yield different answers. Look at the algorithm Continue reading “Excel XNPV Function: Discounting non-Periodic Cash Flows. Algorithm for How it Works! EMT 1761”
Excel & Statistics Busn 210, Week 4, Day 1, Fall Quarter, 2021
For matriculating students in fall, 2021 at Highline College:
Excel & Statistics Busn 210, Week 4, Day 1, Fall Quarter, 2021
Excel MAX Across All Worksheets – 2434
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”
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”