No repeated/duplicated record

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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 ***
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
How to delete non-matching records by comparing with a table 3
Validation Options with option List 2
Excel formula for counting nr records with data and related empty fields 3
New row after every comma "," 5
Import Data into same cell 3
Need Help with MACRO to do CRAZY thing, 5
query? 2

Back
Top