Please confirm you want to mark all posts read
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 🙂
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.
Devices in use: Desktop (7), Phone (4)