is there any way to make data validation doesn't contain empty or duplicates items

[Mussala]

Hi guys

I have three data validations in OUTPUT sheet in columns B,C,D , linked with columns B,C,D for INVOICE sheet like this

=INVOICE !$B$2:$B$100,=INVOICE !$C$2:$C$100,=INVOICE !$D$2:$D$100

what I look for when shows any data validation should not show any empty and any duplicates items , also I want populate the items into data validation dynamically without increase the range manually when I need add more items more than row 100 for each column .

thanks

 

[Akuini]

Great, glad it works & thanks for the feedback.