View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Naveen Naveen is offline
external usenet poster
 
Posts: 100
Default No repeated/duplicated record

First, select the range A1:A100. Then, go to the Data menu, and select the
Validation menu item. This will display the Data Validation dialog. From
the "Allow" drop down box, select Custom, and enter the following formula in
the Formula box:

=COUNTIF($A$1:$A$100,A1)=1

Then, select the "Error Alert" tab, and enter the message you want to
display when the user enters a duplicate value. Finally, press OK.


*** Please do rate ***







"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~