How to identify and mark duplicates

  • Thread starter Thread starter Frank Krogh
  • Start date Start date
F

Frank Krogh

How do I (by using array formulas?) identify and mark duplicates (identical
rows) in the example below ? I want row 1 and 4 to be identified as
duplicates, without specifying actual values as search criteria?



C1 C2 C3 Duplicate

a 4 c x

d 4 f -

a 4 c x

c 2 b -



I have seen the webpage http://www.cpearson.com/excel/duplicat.htm about the
subject, but no help on this particular task.



Thanks for any help

FK
 
Hi Frank
add a helper column (column D) and enter the following formula
=A1&B1&C1
copy this down
now in column E enter the following in E1:
=IF(COUNTIF($D$1:$D$100,D1)>1,"x","")
 
Back
Top