View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cue Cue is offline
external usenet poster
 
Posts: 47
Default 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