| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Check for dual key Duplicates
I have a workbook where I need the user to be able to enter only one entry
for a two column pair. Column A is an identifier number and Column B is a date, so: #1, 10/16/2009 #1, 11/16/2009 #2, 10/16/2009 is valid but, #1, 10/16/2009 #1, 10/16/2009 #2, 11/16/2009 would not be valid. I've thought about concatenating these two fields in another sheet and then doing a vlookup on this table and if it is N/A it would mean it's not previously used, but that seems clunky...As well as doing a loop to determine if it's been used since this sheet can have thousands of entries. Is there a simple way of doing this that I might be missing? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Check for Duplicates then Sum cells of duplicates | Excel Programming | |||
| check for duplicates | Excel Worksheet Functions | |||
| Check for Duplicates | Excel Worksheet Functions | |||
| Check for Duplicates (RP) | Excel Programming | |||
| Check for duplicates | Excel Worksheet Functions | |||
Threaded Mode
