Hello

Can anyone please help me?! I have found a formula that is meant to prevent duplicate data entry, but it doesn't seem to work properly!

I have a large spreadsheet with values in column A. I don't want duplicate values entered anywhere in column A.

Eg - If I have entered 1234-10 in cell A7 and then try to enter the same value in cell A67, I want to be told that it is a duplicate.

I thought I found a solution which was using Data, Validation, Custom and the formula -
=COUNTIF($A$6:$A$3000,A6)=1

BTW - My spreadsheet goes up to row 3000!!

However, this is now telling me that EVERY value I enter is a duplicate even if it isn't already there.

PLEASE HELP ME!!!!!

Thanks
T