Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Preventing Duplicate Entries in rows
Is it possible to set up a formula within Data Validation that will highlight
a duplicate entry within certain cells within a row. E.G. I want the user to enter data in A1,B1,C1,D1,E1 etc, but A1, C1, E1 etc are for staff names - I do not want a name duplicated, the same name can only appear once in a row. Any suggestions. Thanks Andrew |
#2
|
|||
|
|||
Hi
see: http://cpearson.com/excel/NoDupEntry.htm "AJPendragon" wrote: Is it possible to set up a formula within Data Validation that will highlight a duplicate entry within certain cells within a row. E.G. I want the user to enter data in A1,B1,C1,D1,E1 etc, but A1, C1, E1 etc are for staff names - I do not want a name duplicated, the same name can only appear once in a row. Any suggestions. Thanks Andrew |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find duplicate rows then deleting them | Excel Worksheet Functions | |||
I want to delete rows with duplicate entries within one column. | Excel Discussion (Misc queries) | |||
Showing Duplicate rows in excel | Excel Discussion (Misc queries) | |||
Multiple Files, Duplicate Entries | Excel Discussion (Misc queries) | |||
Add numbers for duplicate entries then delete | Excel Worksheet Functions |