I hope I will expose my question clearly :

I have a validation list with, let's say, the following values :
A
B
C
D

Cells from a column are validated against this list. What I would like is
everytime that everytime a value is used, this value si no more available in
the list. Let'w say I pickup C, C is not available for next cell.

Is this doable in a way ?