Excel Hash Sign Operator – What is it + ADVANCED Tricks!

Microsoft Excel Tips and Tricks

The hash sign spill operator enables you to reference spilled arrays returned by dynamic array formulas.

Credit MyOnlineTrainingHub