Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
No repeated/duplicated record
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~ |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
No repeated/duplicated record
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~ |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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~ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to record Macro | Excel Discussion (Misc queries) | |||
Record data on two lines | Excel Discussion (Misc queries) | |||
Record information is on two lines | Excel Discussion (Misc queries) | |||
Can't go to 'Last Record' in one step in a Word doc. linked To Exc | Excel Discussion (Misc queries) | |||
Always show new record | Excel Discussion (Misc queries) |