SOLVED

# Two data validations

Copper Contributor

# Two data validations

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

# Re: Two data validations

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

# Re: Two data validations

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

1 best response

Accepted Solutions
best response confirmed by Grahmfs13 (Microsoft)
Solution