Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I prevent duplicate numbers from being entered in a column.
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? |
#2
|
|||
|
|||
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:D,D1)=1 then set the appropriate error alert in the error alert tab. Bob Umlas Excel MVP "Clearwater Tim" <Clearwater wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data validation to prevent duplicate entry. | Excel Discussion (Misc queries) | |||
prevent duplicate entry for range of numbers 00001 to 99999 in ex. | Excel Discussion (Misc queries) | |||
Prevent duplicate entries | Excel Worksheet Functions | |||
How do you find duplicate values in excel- 2 columns of numbers | Excel Discussion (Misc queries) | |||
Add numbers for duplicate entries then delete | Excel Worksheet Functions |