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?