COUNTIF(A:A,A1)=1

"kyoshirou" wrote:

Hi all,
any1 tried before this?
the column will set it in a way that no repeated/duplicated record is
allowed to enter.

---------------------------------------------------------------------
For example:
Column1
Test1
Test2
---------------------------------------------------------------------
when user enter"test3", it will become like this:
For example:
Column1
Test1
Test2
test3
---------------------------------------------------------------------
But when user enter "Test1", it will prompt the user that record is already
inside. Please enter new record.

Thanks~