View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
...Patrick[_4_] ...Patrick[_4_] is offline
external usenet poster
 
Posts: 3
Default 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