Combining a data validation list with a custom formula (including error message)

Originally Posted by popipipo

Or take a look at this

Thanks for a good proposal, but it will not solve the problem fully. Since it should always be possible to select all options but it should be an error message if you choose an option that is already selected.