Forum Discussion
Conditional Data being used for data validation input.
I may be approaching this the wrong way, but I am looking for a pointer as how to use a single excel data table to populate a series of data validation drop down lists in a separate sheet For exa...
mathetes
Thank you kind sir.
...Of course it is just my luck I am using a Mac so I am running Office 2019 for Mac, so the SORT, UNIQUE and FILTER functions don't exist for me...
All the same, it helped and has given me some pointers...
FWIW, I'm on a Mac as well. But I do have the Microsoft 365 Subscription service going. I'd recommend it. These new functions alone are worth it.