finding duplicate entries
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
|