Hi guys, Welcome to the Advanced Video Search Engine, and you are watching When Should You Use the Hash Sign in Excel Formulas?. That video is uploaded by Leila Gharani at 2021-01-21T02:00:00-08:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [0S5lPoXHX_c]
| Name | When Should You Use the Hash Sign in Excel Formulas? |
| Video Uploader | Video From Leila Gharani |
| Upload Date | This Video Uploaded At 21-01-2021 10:00:00 |
| Video Discription | Join 400,000+ professionals in our courses here 👉 https://link.xelplus.com/yt-d-all-courses The Hash sign or the pound sign (#) in an Excel formula allows you to easily reference an entire spilled range. You can only use this if you have Office 365 version and already have Excel functions like filter, unique and sort. This way Your Excel formula will automatically adjust and include the whole range as soon as the source data changes. ⬇️ DOWNLOAD the workbook here: https://pages.xelplus.com/hash-formula-file I'll show you how and when you can use the # reference in Excel formulas and also when you shouldn't be using the hash reference in your excel formulas. 🔍 Key Takeaways: ▪️ Learn about the use of the hash sign (#) in Excel formulas. ▪️ Understand how and where you can't use the hash sign. ▪️ Discover the concept of spilled ranges in Excel. ▪️ Get insights into practical applications of the hash sign in formulas. ▪️ Find out why you can't use certain functions like Filter, Sort, and Unique in Excel tables. ▪️ Bonus tip: How to select specific parts of a spilled range with the Index function. If your Excel hash reference doesn't work, it's likely because you aren't referencing a spilled range in Excel. It can also be that you're using the reference inside an Excel table. In which case you'll see the spill error message (#spill). In this video I also explain why you can't use dynamic array functions like filter, sort and unique inside excel tables. If you have Excel for Microsoft 365 you already have this functionality. Link to Excel Functions in 2021 video: https://youtu.be/_EWcAR_Hkvg Link to my COMPLETE Excel Course about the NEW Dynamic Array functions: https://courses.xelplus.com/p/excel-dynamic-array-formulas 00:00 What does the Hash / Pound Sign mean in an Excel Formula 06:08 Practical Example for the Hash Sign in Excel 07:18 Why You Can't Use Filter, Sort and Unique in Excel Tables (and other ranges that spill) 09:12 Bonus! How To Select Specific Part of a Spilled Range in Excel with Index Function LINKS to complete playlist about new functions in Excel 365: https://www.youtube.com/playlist?list=PLmHVyfmcRKyyPFY31LldHWcJdLzGUPTSP ➡️ Join this channel to get access to perks: https://www.youtube.com/channel/UCJtUOos_MwJa_Ewii-R3cJA/join 👕☕ Get the Official XelPlus MERCH: https://xelplus.creator-spring.com/ 🎓 Not sure which of my Excel courses fits best for you? Take the quiz: https://www.xelplus.com/course-quiz/ 🎥 RESOURCES I recommend: https://www.xelplus.com/resources/ 🚩Let’s connect on social: Instagram: https://www.instagram.com/lgharani LinkedIn: https://www.linkedin.com/company/xelplus Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support! #Excel #Office365 0S5lPoXHX_c |
| Category | Education |
| Tags | XelplusVis | Leila Gharani | Advanced Excel tricks | Excel online course | Excel tips and tricks | Excel for analysts | Microsoft Excel tutorials | Microsoft Excel | Excel 2016 | Excel 2013 | Excel 2019 | XelPlus | Microsoft 365 | Excel 365 | excel formulas and functions tutorial |
