The best way to do this is by converting your data to an Excel table. Select your data range (A1:E11), press Ctrl + T, and click OK. Excel names it something like "Table1"; in my case, it's Table3, ...
Hosted on MSN
Everything You Need to Know About Spill in Excel
Most formulas in Excel return a single-cell result. However, if an Excel formula returns a set of values, the result will spill over to neighboring cells. Spilling and dynamic array formulas are not ...
Results that may be inaccessible to you are currently showing.
Hide inaccessible results
Feedback