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...
Attached is an example workbook I created for similar purposes. You should be able to copy the concepts from this. Come back with questions if you have them.
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.