Care to give some examples of "ph. no."?
PS. There is really no need for multiple posts regarding the same question.
==========
Sorry for multiple post. It was by mistake.
Ph. No. mean phone number, or any contact no. that can have more than one value like fax no. etc.
OK. It looks like you're after
=COUNTIF($A$1:A1,"*"&A2&"*")=0
which is a modified version of the earlier formula for the input conntrol.
Aladin
======
Sir,
Its not perfact solution cuz if there is single character that matches the chacrater of above column it would prompt error.
Is there any possiblity to use function like mid or substr
bye
I see what you mean. I should have known that. It might be hard to meet the specs I'm afraid.
Just curious: Can you give a short list of values that you want to input?
Aladin
=========
Hi,
Name Office_Tel
Abc 222,589,6000
Def 6000,896,756
Geh 585,456,900
Ijk 789,458,785
Hi want to get the messege of 6000 too cuz its in two rows.
Regards
Hayi