Hi everyone, my first post and hope I make myself understandable...
I'm trying to use the dropdown list function, so that I can find a specific data from a table. But I'm having a long list and would like to add conditions to it.
I've seen people using dependent lists to solve similar problems, but since my list is a live one and it keeps expanding. Is there a way that Excel could list out the data that matches with the condition, perhaps like an if-function?
Would be very great if you guys can help! Thanks!
Bookmarks