Dec 27 2022 03:11 PM
Is it possible that one cell contain two data validations? For example A1 contains a data validation for a drop down menu under "list" and a data validation under "custom"?
Dec 28 2022 05:11 AM
That was it, thank you! @Rr_. How would you combine these two functions using the "=OR"
=COUNTIF(B$32:B$59,"=P")+COUNTIF(B$32:B$59,"=CP")<= B$61
=COUNTIF($AL$2:$AL$16,B26)=1
I tried doing
=OR(COUNTIF($AL$2:$AL$16,B26)=1,AND(B26>=(B$26:B$28,"=O")<= B$30))) but I get an error message
Dec 28 2022 07:53 PM
@vcastle
You're having an error message because you do not have a function on your "(B$26:B$28,"=O")" formula....
maybe try adding countif function on that.
=OR(COUNTIF($AL$2:$AL$16,B26)=1,AND(B26>=COUNTIF(B$26:B$28,"=O")<=B$30))