Hi everyone.
Column A has a list of names
Column B has a YES or a NO - This changes periodically from YES to NO and NO to YES
I would like to have a data validation that uses the list in column A but only those that have currently have a YES in column B.
Side Note - I need to do this without naming a range of any kind
What formula can I use in the data validation to return a list from column A where the corresponding cell in column B = YES?
Bookmarks