Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Preventing Duplicate Entries within a column
Is there an easy way to prevent creating duplicate
entries within a given column in Excel? Alternately....is there a way to automatcially highlight a cell / row when a duplicate entry is created within a given column? |
#2
|
|||
|
|||
If they are typed in yes it is easy
http://www.cpearson.com/excel/NoDupEntry.htm or to tag them http://www.cpearson.com/excel/duplicat.htm Regards, Peo Sjoblom "Bruce" wrote: Is there an easy way to prevent creating duplicate entries within a given column in Excel? Alternately....is there a way to automatcially highlight a cell / row when a duplicate entry is created within a given column? |
#3
|
|||
|
|||
Assuming your entry-range begins in A3 and downward to A100
Select Cell A4, then at the menu, select Data, Validation, Allow: Custom In the formula Box enter: =IF(COUNTIF($A$3:$A4,$A4)1,FALSE,TRUE) then OK (out). While A4 is Blank or empty, Copy it and paste from A5:A100. Done. HTH "Bruce" wrote in message ... Is there an easy way to prevent creating duplicate entries within a given column in Excel? Alternately....is there a way to automatcially highlight a cell / row when a duplicate entry is created within a given column? |
#4
|
|||
|
|||
To highlight duplicates:
Select column A From Format menu | Conditional Formatting Formula Is: =COUNTIF($A:$A, $A1)1 Then format as Bold, or Red or whatever. -- Rob van Gelder - http://www.vangelder.co.nz/excel "Bruce" wrote in message ... Is there an easy way to prevent creating duplicate entries within a given column in Excel? Alternately....is there a way to automatcially highlight a cell / row when a duplicate entry is created within a given column? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filtering a column to exclude any repeated entries. | Excel Discussion (Misc queries) | |||
how do i see if entries in one column are in another column? | New Users to Excel | |||
I want to delete rows with duplicate entries within one column. | Excel Discussion (Misc queries) | |||
Preventing Duplicate Entries in rows | Excel Worksheet Functions | |||
Add numbers for duplicate entries then delete | Excel Worksheet Functions |