Combo Validations with List's

[Ben]

How do I add the following data validation [ =a1<>0 ]to
an already existing list validation?

Thanks

Ben

 

[Peo Sjoblom]

Use AND

=AND(A1<>0,existing_condition)

 

[Ben]

-----Original Message-----
Use AND

=AND(A1<>0,existing_condition)

--

Regards,

Peo Sjoblom

How do I add the following data validation [ =a1<>0 ]to
an already existing list validation?

Thanks

Ben

.

 

[Ben]

I get and error..what is wrong with this?
=AND(a1<>0,$P$3:$P$1003)
----------------------
"The list source must be a delimited list, or a reference
to a single row or column."

Ben

-----Original Message-----
Use AND

=AND(A1<>0,existing_condition)

--

Regards,

Peo Sjoblom

How do I add the following data validation [ =a1<>0 ]to
an already existing list validation?

Thanks

Ben

.

 

[Peo Sjoblom]

Sorry, I misread your question, you cannot combine a dropdown list with
validation in another cell,
you could use a macro solution that would ask the user for an input in A1.

--

Regards,

Peo Sjoblom

I get and error..what is wrong with this?
=AND(a1<>0,$P$3:$P$1003)
----------------------
"The list source must be a delimited list, or a reference
to a single row or column."

Ben

-----Original Message-----
Use AND

=AND(A1<>0,existing_condition)

--

Regards,

Peo Sjoblom

How do I add the following data validation [ =a1<>0 ]to
an already existing list validation?

Thanks

Ben

.