Firstly set the data validation criteria of C1 to the cell range A:A. Then you could fill column B with =IF(EXACT(A1,$C$1),"",A1), which would be every value of A, except for the one selected in C1. Finally set the data validation criteria of C2 to the cell range B:B.