| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I find dups across different columns
I have a spreadsheet where I need to find dups. For instance col 1 will have
an ID but col5 will have name. There can be several instances of the same ID but with different names in col5. I want to find all the dups across col1 and col5. I am currently using the following formula: =IF(COUNTIF($A$1:$A$100,A1)1,"Dup","Not Dup") How can I enhance this to include looking for dups across column5? Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Dups in Two Columns | Excel Worksheet Functions | |||
| Total Number of Dups in 2 columns | Excel Worksheet Functions | |||
| Macro - find dups & add | Excel Discussion (Misc queries) | |||
| Comparing two columns for dups | Excel Discussion (Misc queries) | |||
| highlight dups in one of two columns | Excel Worksheet Functions | |||
Threaded Mode
