Shrinking Data Validation Drop List with a column in between

[mrp80]

Hello All,

This is my first post, I've looked though the forums and I've found some items that come close but not exactly what I'm looking for.

I'm working on shrinking drop down list with data validation. I'm able to get it working while using 1 column and adjacent columns, the issue comes when I try to get it working with a column in between.

working
=if(countif($A$1:$A$6,Q1)>=1,"",row()) or =if(countif($A$1:$B$6,Q1)>=1,"",row())

too many arguments error
=if(countif($A$1:$A$6,$C$6:$C11,Q1)>=1,"",row())

I need that column in the middle to add other data. Is there a way to get it working or am I just out of luck?

I have a sample sheet with everything to include the error, i just don't see how to share it.

Any assistance would be greatly appreciated.

Thank you

---

 

[pbornemeier]

Will this work for you?

=IF(COUNTIF($A$1:$A$6,Q1)+COUNTIF($C$6:$C11,Q1)>=1,"",ROW())