SOLVED

Two data validations

New Contributor

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"?

3 Replies
best response confirmed by Grahmfs13 (Microsoft)
Solution

That was it, thank you! @rrestrivera. 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 

@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))