MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Another form of Duplication


Posted by A.Hayi Mansoor on January 21, 2002 11:52 PM

Hi,
I asked a question regarding data duplication while entring data. i got the answer of that question. Now
I am having another problem
Some people have more than two ph. no. and i have put them all those in single cell. The problem is that i want to generate the duplication message if any of those no. matches to the newly enter ph. no.
Is there any possibility to do so.
Bye
Hayi


Posted by Aladin Akyurek on January 22, 2002 12:00 AM

Care to give some examples of "ph. no."?

PS. There is really no need for multiple posts regarding the same question.

==========

Posted by A.Hayi Mansoor on January 22, 2002 12:07 AM

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.

Posted by Aladin Akyurek on January 22, 2002 12:24 AM

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

======

Posted by A.Hayi Mansoor on January 22, 2002 1:03 AM

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

Posted by Aladin Akyurek on January 22, 2002 1:29 AM

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

=========

Posted by A.Hayi on January 22, 2002 9:07 PM

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