Dec 31 2018
06:54 PM
- last edited on
Feb 01 2023
09:59 AM
by
TechCommunityAP
Dec 31 2018
06:54 PM
- last edited on
Feb 01 2023
09:59 AM
by
TechCommunityAP
Hi
I want to add a dropdown list that at the same time exclude data from previous rows. I'm trying to make a schedule that is a bit complicated and I want to avoid selecting the same person more than twice in the same row. I can either do a drop down list with all names or do custom data validation to avoid entering the same name if it matches one or more of the previous cells in the same row. I can't do both, and I wonder if I can combine both.
I tried using match and lookup functions but the script gets long (as I am trying to do all possible combinations) and it is not accepted in the formula box of the data validation list.
Please note the attachement for more details
Jul 15 2019 04:14 PM