View Single Post
  #3   Report Post  
Alan
 
Posts: n/a
Default

Sorry, that should be
=IF(COUNTIF(A:A,A1)1,1,"")

"-Adrianna_" wrote in message
...
I have a large list of Alpha/numeric codes and I need to determine if any
of
the codes are duplicated. Of course I have sorted the column and done if
manually but the list is up to 4000 rows long (a monthly occurance) and i
almost make myself blind doing it by eyesight.I have tried IF formulae but
to
no avail, I am a little stuck and even our IS department are unsure as to
what to do.
Any ideas?