How do I prevent duplicate numbers from being entered in a column.

[Guest]

I am trying to set a check register example and want to prevent the user from
entering the same check number twice. Is this possible in Excel?

 

[Bob Umlas]

Select the column, assuming D1 is the active cell, for example, do this:
Use Data/Validation, select Custom from the first dropdown, enter this in
the Formula:
=Countif(D,D1)=1
then set the appropriate error alert in the error alert tab.

Bob Umlas
Excel MVP