P
pg23673
I am entering unique serial no. in col A. Can I set up a rule which will not
allow a duplicate serial no. entry into another cell?
allow a duplicate serial no. entry into another cell?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JE McGimpsey
B
bj
Check out the validation in the Data section.
select the area of interest (A:A)
<data><validation><Settings><Custom>
enter =countif(A:A,A1)=1
Set the error alert as you want it
select the area of interest (A:A)
<data><validation><Settings><Custom>
enter =countif(A:A,A1)=1
Set the error alert as you want it
G
Gary Brown
If you put a Custom Data Validation as follows:-
=IF(MATCH(A1,A:A,0)<>ROW(A1),FALSE,TRUE)
This assumes that you are putting the serial number in column A, adjus
accordingly if this is not the cas
=IF(MATCH(A1,A:A,0)<>ROW(A1),FALSE,TRUE)
This assumes that you are putting the serial number in column A, adjus
accordingly if this is not the cas
D
Dave Peterson
Chip Pearson has something that can help:
http://www.cpearson.com/excel/NoDupEntry.htm
http://www.cpearson.com/excel/NoDupEntry.htm
P
pg23673
Thanks for the help guys.