| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Finding duplicates
How do I write a formula that looks at two columns and looks for
duplicate values in both, and flags the row if it finds them in? See below example I would want to look at columns A and B and look for duplicate values in both columns A B 123 abc 124 def 125 ghi 126 jkl 126 mno 126 mno 127 pqr |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding duplicates | Excel Discussion (Misc queries) | |||
| Finding duplicates | Excel Discussion (Misc queries) | |||
| Finding Non-Duplicates | Excel Worksheet Functions | |||
| help...finding duplicates | Excel Worksheet Functions | |||
| Finding Duplicates | Excel Worksheet Functions | |||
Threaded Mode
