Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Restrict Duplicates using Data Validation
How Can i Restrict Duplicates using Data Validation
Means if I have Hardeep in A1. And i want to Enter Hardeep in A20, It show me the Error Message Thanks in Advance Hardeep kanwar |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Restrict Duplicates using Data Validation
Select A1
In Data Validation select Custom Insert the following formula =NOT(COUNTIF(A1:A$1,A1)1) Copy down the cell. "Hardeep Kanwar" wrote: How Can i Restrict Duplicates using Data Validation Means if I have Hardeep in A1. And i want to Enter Hardeep in A20, It show me the Error Message Thanks in Advance Hardeep kanwar |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Restrict Duplicates using Data Validation
Thanx for Quick Reply
But its not Working "FARAZ QURESHI" wrote: Select A1 In Data Validation select Custom Insert the following formula =NOT(COUNTIF(A1:A$1,A1)1) Copy down the cell. "Hardeep Kanwar" wrote: How Can i Restrict Duplicates using Data Validation Means if I have Hardeep in A1. And i want to Enter Hardeep in A20, It show me the Error Message Thanks in Advance Hardeep kanwar |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Restrict Duplicates using Data Validation
Send me your email address if you want a sample file.
By the way what version are using? "Hardeep Kanwar" wrote: Thanx for Quick Reply But its not Working "FARAZ QURESHI" wrote: Select A1 In Data Validation select Custom Insert the following formula =NOT(COUNTIF(A1:A$1,A1)1) Copy down the cell. "Hardeep Kanwar" wrote: How Can i Restrict Duplicates using Data Validation Means if I have Hardeep in A1. And i want to Enter Hardeep in A20, It show me the Error Message Thanks in Advance Hardeep kanwar |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Restrict Duplicates using Data Validation
Sorry Sir
MY Mistake Ifs Working Thanks and sorry "Hardeep Kanwar" wrote: Thanx for Quick Reply But its not Working "FARAZ QURESHI" wrote: Select A1 In Data Validation select Custom Insert the following formula =NOT(COUNTIF(A1:A$1,A1)1) Copy down the cell. "Hardeep Kanwar" wrote: How Can i Restrict Duplicates using Data Validation Means if I have Hardeep in A1. And i want to Enter Hardeep in A20, It show me the Error Message Thanks in Advance Hardeep kanwar |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Restrict Duplicates using Data Validation
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Restrict Duplicates using Data Validation
Hardeep, for more on data validation refer the below thread.
http://www.contextures.com/xlDataVal01.html If this post helps click Yes --------------- Jacob Skaria "Hardeep Kanwar" wrote: How Can i Restrict Duplicates using Data Validation Means if I have Hardeep in A1. And i want to Enter Hardeep in A20, It show me the Error Message Thanks in Advance Hardeep kanwar |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation - Restrict entry but without dropdown | Excel Discussion (Misc queries) | |||
Data Validation to restrict blank value in adjacent field | Excel Discussion (Misc queries) | |||
validation list with no duplicates | Excel Discussion (Misc queries) | |||
Duplicates in database validation | Excel Discussion (Misc queries) | |||
Excel2000: Data Validation to restrict entries | Excel Discussion (Misc queries) |