Excel Dynamic Arrays
What are dynamic arrays in Excel? Dynamic arrays are new to Excel and are available in Microsoft 365 […]
spill
Excel’s Hash Reference
What is the hash symbol that you see in some formulas? What does it do? If you have […]
Excel Filter Function
The new Excel FILTER function is one of the new dynamic arrays that are available in Microsoft 365. […]
Excel Spilled Ranges
What is an Excel spilled range? First of all, a range in Excel is a collection of two […]