Excel unique 4 digit random numbers

I want to program a column in excel to produce a unique 4 digit random numbers and to take into consideration the previous numbers that were in the column. For example, if 3333 is already there I want it to skip it and put another random number. Any ideas how can I do it? any suggestion is appreciated.

Thank you.