finding duplicate entries
=countif($A$2:$A$1000,A2) 1 !!!! sorry
"...Patrick" a écrit dans le message de
...
In french:
in conditionnal format:
=nb.si($A$2:$A$1000;A2)
in xl english nb.si=countif replace ";" by "," and chose a color
conditionnal :-))
...Patrick
"Jack" a écrit dans le message de
...
I have a list of zip codes (thousands of them) in a
column, is there a command that will find duplicate
numbers and turn them red?
thanks
|