Wednesday, February 10, 2010

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

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.h鈥?/a>





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?Why does =IF(COUNTIF(Range1, A5)%26gt;1,TRUE,FALSE) not work in Excel 2000?
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 (swinkate@yahoo.co.uk) for an example!!





KateWhy does =IF(COUNTIF(Range1, A5)%26gt;1,TRUE,FALSE) not work in Excel 2000?
You need to define 'Range1'

No comments:

Post a Comment