| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Marking Duplicates
I have a large spreadsheet(7000 entries) that I would like to mark any of the
row that are duplicates. In order to match the duplicates columns A B C have to be the same. I have attempted to use the following but it does not seem to work: =IF(COUNTIF(A:C,A2)1,"Duplicate","") I place this in column D then copy it down through the spreadsheet. Thanks for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to remove duplicates from a list and copy new list to new colu | Excel Worksheet Functions | |||
| Help with Highlighting all duplicates in a row | Excel Discussion (Misc queries) | |||
| Finding Duplicates | Excel Worksheet Functions | |||
| Finding Duplicates and somehow flagging them in another column | Excel Discussion (Misc queries) | |||
| removing duplicates testing in 2 coloms | Excel Worksheet Functions | |||
Threaded Mode
