Nikki Day-Childs
New Member
Members
Forum Posts: 1
Member Since:
September 13, 2019
September 13, 2019
Offline
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 🙂
Mynda Treacy
Admin
Forum Posts: 4703
Member Since:
July 16, 2010
July 16, 2010
Offline
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
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Bec Mathie
Guest(s) 9
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 286
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Jeffree Bunning
Jackie Memije
John Franzon
Darcie Clayton
trevor mir
Ruby White
Marisa Bradshaw
Eugene Augustine
MacNaughton Finance
Tanu Rai
Forum Stats:
Groups: 3
Forums: 24
Topics: 6872
Posts: 30119
Member Stats:
Guest Posters: 49
Members: 33667
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —