Category: Business

Determine Cause of #N/A! Errors in XLOOKUP & VLOOKUP & Fix Them! Hidden Character Problem. EMT 1868

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1868.xlsx
Learn how to detect what hidden characters are causing N/A! Errors In XLOOKUP And VLOOKUP And Fix It!
Many functions in this video: CODE, CHAR, RIGHT, TRIM, LOOKUP, XLOOKUP, ARRAYTOTEXT, REDUCE, LAMBDA, SUBSTITUTE, REGEXREPLACE, REGEXTEST, UNICODE, and more!
ExcelLambda from YouTube supplies awesome solution!
Topics:
1. (00:00) Introduction.
2. (00:27) Using XLOOKUP and getting an #N/A Error.
3. (01:12) What cause #N/A? Hidden characters that are unknown.
4. (01:40) Check for hidden characters at end of lookup value with RIGHT & CODE function to check.
5. (02:29) Lookup Ascii codes to figure out what it is? LOOKUP function.
6. (03:42) TRIM to Continue reading “Determine Cause of #N/A! Errors in XLOOKUP & VLOOKUP & Fix Them! Hidden Character Problem. EMT 1868” →

Determine What Causes N/A! Errors In XLOOKUP &VLOOKUP & Fix It! Hidden Characters Problem. EMT 1868

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1868.xlsx
Learn how to detect what hidden characters are causing N/A! Errors In XLOOKUP And VLOOKUP And Fix It! I answer the question: Can you use SUBSTITUTE for many values without nesting? The answer is yes!
Learn how to get the SUBSTITUTE function to replace more than one value! Other ways to phrase this issue:
Multiple Replacements with Excel
Substitute multiple values
SUBSTITUTE function with dynamic array
Excel substitute function array of substitute values
Excel: find and replace multiple values at once
Excel substitute multiple sub text strings with one formula
Excel – Can you use SUBSTITUTE for many values without nesting?
Many functions Continue reading “Determine What Causes N/A! Errors In XLOOKUP &VLOOKUP & Fix It! Hidden Characters Problem. EMT 1868” →

Spreadsheet Construction Busn 218 Class @ Highline College, 2025 Winter by Mike “excelisfun” Girvin

Posted on by Annie D

For matriculating students at Highline College, but videos and files free at YouTube: https://www.youtube.com/playlist?list=PLrRPvpgDmw0k7ocn_EnBaSJ6RwLDOZdfo

Spreadsheet Construction Busn 218 Class @ Highline College, 2025 Winter taught by Mike “excelisfun” Girvin

Highline College Statistical Analysis Busn 210 Class 2025 Winter taught by Mike “excelisfun” Girvin

Posted on by Annie D

For matriculating students at Highline College, but videos and files free at YouTube: https://www.youtube.com/playlist?list=PLrRPvpgDmw0m3oqpp1XcPuaxyM4Bpi0dN

Highline College Statistical Analysis Busn 210 Class 2025 Winter taught by Mike “excelisfun” Girvin

Excel I Need A Once In A Lifetime Formula For 2025 – Episode 2665

Posted on by Annie D

Microsoft Excel Tutorial: Looking for a great formula to format 2025 cells.

To download the workbook from today: https://www.mrexcel.com/youtube/_sJiLN5edko/

Start 2025 with a bang by diving into an Excel adventure like no other! In this tutorial, we explore the fascinating concept of “square years”—numbers that are perfect squares of whole numbers—and why 2025 (45 squared) is truly a once-in-a-lifetime event. We’ll walk you through formulas and creative techniques to visualize this unique year in Excel, while tying it back to historical milestones like the California Gold Rush and the completion of the Hoover Dam.

Discover how to create Continue reading “Excel I Need A Once In A Lifetime Formula For 2025 – Episode 2665” →

Conquering Excel’s Formatting Quirks with Creative Hacks – Episode 2664

Posted on by Annie D

Microsoft Excel Tutorial: Can you mix formatting in an Excel cell that contains a formula?

How to Work Around Excel’s Formatting Limitations

Ever wondered if you could apply different formatting to parts of a cell populated by a formula in Excel? In today’s video, we dive into this intriguing question posed by Paul, a viewer who couldn’t find a solution to this common Excel conundrum. While Excel doesn’t allow partial formatting of a formula’s result, I’ve discovered a clever workaround using the **Paste Linked Picture** feature. Watch as I demonstrate this creative hack step-by-step!

We start with a fundamental Excel tip: Continue reading “Conquering Excel’s Formatting Quirks with Creative Hacks – Episode 2664” →

2024 Christmas Tree with Excel Formula

Posted on by Annie D

ExcelLambda at YouTube (Xlambda at mrexcel.com/board/) invented a cool formula to create an Excel Christmas tree with worksheet formulas. He posted the formula at: https://www.mrexcel.com/board/threads/axmas.1191144/page-4

Merry Christmas and Happy Holidays to all!!!! : )

Workbook file download: https://people.highline.edu/mgirvin/AllClasses/excelisfun/EMT1867-Xmas2024.xlsx

Also, check out our Teammates X-mas video here:
Henriette Hamer (Sledgehammer Productions) 2024 Christmas Video at YouTube:
Xmas2024 – ExcelIsFun mantle: https://www.youtube.com/watch?v=ZcycuozQWYo

MS 365 Excel Basics 06: XLOOKUP, FILTER, XMATCH, LOOKUP, SWITCH Functions to Solve Any Lookup Task!

Posted on by Annie D

Download Excel File: https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelBasics06.xlsx
Read (download right-click): pdf notes: https://people.highline.edu/mgirvin/AllClasses/218M365/Content/ExcelBasics06.pdf
In this video learn about the most amazing lookup function in Excel: XLOOKUP Function, which can do 10 or more lookup tasks. Also learn about when you must use other lookup functions such as: LOOKUP, FILTER, SWITCH and XMATCH. Also see extensive examples of why for approximate match lookup, you should use the LOOKUP function, not XLOOKUP!
Topics:
1. (00:00) Introduction
2. (00:31) Topics in video
3. (01:26) Problems with AI and Excel
4. (04:28) XLOOKUP arguments
5. (05:27) Exact Match Lookup to lookup a product price
6. (07:26) Data Validation to Continue reading “MS 365 Excel Basics 06: XLOOKUP, FILTER, XMATCH, LOOKUP, SWITCH Functions to Solve Any Lookup Task!” →

Your Microsoft Fabric Is a Mess Without DOMAINS!

Posted on by Annie D

Have you been using Domains? They are a great way to organize items within Microsoft Fabric and to allow delegation of tenant settings. Adam shows you what they are all about!

Fabric domains
https://learn.microsoft.com/fabric/governance/domains

Best practices for planning and creating domains in Microsoft Fabric
https://learn.microsoft.com/fabric/governance/domains-best-practices

📢 Become a member: https://guyinacu.be/membership

*******************

Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.

🎓 Guy in a Cube courses: https://guyinacu.be/courses

*******************
LET’S CONNECT!
*******************

— http://twitter.com/guyinacube
— http://twitter.com/awsaxton
— http://twitter.com/patrickdba
— <a href="http://www.facebook.com/guyinacube" Continue reading “Your Microsoft Fabric Is a Mess Without DOMAINS!” →