Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
14
Views
Topic starter
Hi! I am looking for some help with the attached spreadsheet. My Module Code dropdown list (N3) is including all the cells where the INDEX formula produces a #NUM! error (which has been changed to "" using IFERROR) - is there any way of getting the list to only display the cells within the PathwaysTable where text is visible? Thank you ๐
Posted : 13/09/2019 11:26 am
Hi Nikki,
Welcome to our forum!
If you're using Office 365 then you can use the UNIQUE function to return the list ignoring errors and blanks. Alternatively, you could use this dependent data validation technique.
Mynda
Posted : 13/09/2019 7:30 pm