duplicates

  • Thread starter Thread starter james
  • Start date Start date
J

james

i have names in 3 columns: a,b,and c. is there a way to filter out the
duplicates in all the columns? i want to check against A. so if any name in
B or C appear in A i want to mark.

TIA

James
 
Filter out? Well, first let's mark them using conditional formatting. Select
all the data and Format>Conditional Formatting>Formula Is>

=COUNTIF($A$2:$C$100,A2)>1

Format for the change if TRUE*>OK.
 
Back
Top