I have a file that contains duplicate supplier records and I want to be able
to identify where a supplier number is duplicated and then delete all but 1
of the duplicate records. I was given a COUNTIF formula but it is not
working.

I was told to add 2 columns and in the first blank column type =Row() in the
cell. In the second blank column type =IF(COUNTIF(A$1:$A1,A1)1,0,1)

My supplier numbers start in Column A Row 2. How can I get this to work?

--
Thank you,

Jodi