Remove duplicate values from the dropdown list

[jin0109]

Hi Masters!
Do you know how to remove duplicate values from the dropdown list?
Please find attached file.

Thank you so much for your help!

[jeffreybrown]

Yes, create a table to the side with just Yes and No and then link your data validation to the new table.

[jin0109]

Do we have any formulas that we can use instead of creating another table?

[jeffreybrown]

Not within data validation, but if you don't want the table, then type the value directly into the data validation.