Excel, find duplicates..

1 post / 0 new
benzzon
benzzon's picture
Excel, find duplicates..

Hitta dubbletter i Excel, inom 1 kolumn..

 
How do I find duplicate entries in a column in an Excel worksheet?
 
 
 
=IF(COUNTIF(A$1:A$7,A1)>1,"Duplicated","")
Change A$1:A$7 to include your whole range in column a, as perhaps A$2:A$1504