Excel: When Should You Use the Hash Sign (#) in a Formula?
Dynamic Arrays and Spilling have completely transformed the way users create formulas in Excel. However, the unsung hero in this revolution is the hash sign (#). Its integration with Dynamic Arrays is a game-changer, yet it hasn't been in the limelight as much as it deserves.
In this video, I'll take you through hands-on examples to show you how Dynamic Arrays, Spilling, and the critical role of the Hash sign seamlessly work together to streamline your Excel workflows.
Note: This functionality is only available to Excel 365 and Excel 2021 users.
🗒 Notes and Resources
Download a copy of the file used in this video: https://app.box.com/s/2uu6zo5hzb2kz1o...
The formulas that I used in the demos:
=B2+1000
=B2:B7 + 1000
=SUM(C2#)
=DAYS(C2,B2)
=AVERAGE(D2:D24)
=DAYS(C2:C24,B2:B24)
=AVERAGE(D2#)
=CHOOSECOLS(FILTER(Transactions,Transactions[Type]="CR"),1,2)
=SUM(CHOOSECOLS(E5#,2))
✅ Want more FREE training?
Why not check out my other tutorials and/or subscribe to my newsletter, both of which can be done at https://theexceltrainer.co.uk
🙋♂️ Let's connect on social
Twitter: / theexceltrainer
Facebook: / theexceltrainer
LinkedIn: / thomasmik
#excel #hash #dynamicarrays #spillrange