Error message

Deprecated function: The each() function is deprecated. This message will be suppressed on further calls in _menu_load_objects() (line 579 of /www/webvol38/16/9svvwb3gxs5tmhv/benzzon.se/public_html/includes/menu.inc).

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