MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Excel 2019: Use # "The Spiller" to Refer to All Array Results


September 18, 2019 - by Bill Jelen

Excel Use #

In this screenshot, the UNIQUE function is in cell F5.

=UNIQUE(D4:D6132) returns a list of genres such as Rock, Easy, Vocal, Pop, R&B, Country, Folk

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


Bill Jelen is the author / co-author of
MrExcel LX – The Holy Grail of Excel Tips

A book for people who use Excel 40+ hours per week. Illustrated in full color.