Forum

Matching three cell...
 
Notifications
Clear all

Matching three cell data with one cell data - different pattern

4 Posts
2 Users
0 Reactions
65 Views
(@perusjosh)
Posts: 2
New Member
Topic starter
 

Hi ,

Please help me with macro to match different cell data with one cell data.

the result column should be True or False 

If match  - it should be true

if not match  - it should be False

i have attached sample.

 
Posted : 21/09/2018 7:38 am
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

Hi,

There is no sample document.  Please try uploading it again.

Thanks

Phil

 
Posted : 21/09/2018 7:49 am
(@perusjosh)
Posts: 2
New Member
Topic starter
 

hi, Any one can help me for this.

Thanks in advance

 
Posted : 23/09/2018 3:28 am
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

Hi,

There isn't any consistent pattern to be able to match.  The first line is the name Adam Moore and you are looking for the pattern adam.p.moore and you have flagged that as a match.

How would I know that this is a match?  What about the middle inital p ?  Would the name Adam Moorefield also be a match?

Sometimes you are matching just the first letter of the first name and the middle and last names (Ah Kane Jean Pierre), sometimes it's matching the first 2 letters of the first name (Assan Mbye).

There are too many variations that are considered a match for me to be able to write code that would match all of these.

You really need the data in a consistent form.  The 'pattern' looks like the first part of an email address and this varies too much to know what is and isn't considered a match for it.

Regards

Phil

 
Posted : 25/09/2018 1:06 am
Share: