To me, eliminate errors where possible, then you don't have to deal further with them.

Dave's solution uses a macro to flash an error if a duplicate entry is attempted. The duplicate value is still in the DV list. All this just shows that there are many ways to "slay the cat" in Excel. The only thing that matters is that the solution suits the person who is going to use it.