MarvinP,

I'm using Office 365 (a much newer version than 2016) and my understanding is Dynamic Arrays are not in General Availability - only limited members in the Excel Insiders program have access to these features. But yes, if the functionality was generally available, I could use the new =UNIQUE and =SORT functions to meet my needs.

You (or anyone else) have any ideas on how to accomplish this with arrays?