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

Microsoft Excel Tricks

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.

Credit Leila Gharani