Why does =IF(COUNTIF(Range1, A5)>1,TRUE,FALSE) not work in Excel 2000?

Question

I have a database with a load of product codes and have to make sure duplicates are changed to some other value.

I found a few ways to find duplicates on:

http://www.cpearson.com/excel/duplicat.htm

but only testing for duplicate entries works in Excel 2000 on my PC.

Highlighting Duplicate Entries seems to do nothing. have tried background colour and italic text but no go.

Tagging Duplicate Entries results in #NAME? in every cell

Code doesn't just change between Excel97 and 2000? What am I doing wrong?

Answer 1

I do this to find duplicates in a list..

Sort data by product code.
In an empty column type =if(a1=a2,"duplicate","ok") in the first row of data.
where a2 is the first product code and a1 is the cell above. Copy this down the column to end of data

Hope this makes sence!
Feel free to e-mail me ([e-mail]) for an example!!

Kate

Answer 2

You need to define 'Range1'