When Should you Use the Hash Sign (#) in Excel Formulas?

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. 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. 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 20