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~ |
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~ |
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~ |
All times are GMT +1. The time now is 06:02 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com