Thanks for responding MarvinP. Unfortunately, Excel Macros are disabled by Windows Group Policy in our organization so I cannot use this solution. Also cannot use VBA because it is not supported on SharePoint online.
Maybe there's a two step process - one array to get all of the Offers based on the Region and a separate function in the Data Validation List field that only retrieves the the unique values from that array.
Possible?
Bookmarks