| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
duplicates
I need to specifically check for duplicates between two columns:
For example: col1 col2 12345 1102897 4794848974 8347474 493836 1102897 What formula can I use to check the data from col 2 against the data from col 1? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
duplicates
=IF(COUNTIF($A:$A,B1)0,"Duplicate","")
and copy down -- HTH RP (remove nothere from the email address if mailing direct) "Danbmarine" wrote in message ... I need to specifically check for duplicates between two columns: For example: col1 col2 12345 1102897 4794848974 8347474 493836 1102897 What formula can I use to check the data from col 2 against the data from col 1? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Deleting Duplicates | Excel Worksheet Functions | |||
| Find duplicates then calculate..??? | Excel Worksheet Functions | |||
| Find and mark duplicates | Excel Discussion (Misc queries) | |||
| Finding Duplicates | Excel Worksheet Functions | |||
| Finding Duplicates and somehow flagging them in another column | Excel Discussion (Misc queries) | |||
Linear Mode
