Hi,

I have problem that I can’t solve.

I want to combine a data validation list with a custom formula (including error message).

In the cells e3:e5 I want to have drop down list with the choice “low”, “medium” and “high” but you should only be able to select a value (“low”, “medium” and “high”) once. That is to say, you have chosen value “low” in the first cell, you should receive an error message, that says something about only unique values are allowed, if you choose low again.

Thanks in advance