Excel 2020: Use # "The Spiller" to Refer to All Array Results
September 23, 2020 - by Bill Jelen
In this screenshot, the UNIQUE function is in cell F5.
You never really know how many results that formula will return.
To refer to "the entire array returned by the formula in F5", you would write F5#. There is no official name for this notation, so I am using an idiom coined by Excel MVP Ingeborg Hawighorst: The Spiller.
Title Photo: Saffu at Unsplash.com
This article is an excerpt from MrExcel 2020 - Seeing Excel Clearly.