| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find Duplicates Rows Based Own Multiple Columns
I'm trying to identify rows that are duplicates based on data in 3 columns.
A B C 1 ANT BEE NO 2 ANT BEE 3 DEF FUN 4 ANT BEE NO 5 DEF FUN NO 6 EAR RUN NO 7 DEF FUN NO 8 EAR RUN The formula I have: =IF(MAX(COUNTIF($A$1:$A$8,A1)*($B$1:$B$8,B1)*($C$1 :$C$8,C1))1,"Duplicates","No Duplicates") Can someone make this work or have a better solution? Thanks in advance. Cue |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to delete duplicates based on data in 2 columns? | Excel Discussion (Misc queries) | |||
| Finding duplicates based on 2 columns | Excel Worksheet Functions | |||
| find number in multiple columns and rows | Excel Worksheet Functions | |||
| Counting rows based on multiple columns | Excel Worksheet Functions | |||
| Compare data in two columns to find duplicates. | Excel Discussion (Misc queries) | |||
Threaded Mode
