Partial Match VBA

[mouaffaq]

Hi profs;

I have this Challenge>>>

I want to do partial match in the same column i.e.

Match A1 with all the column $A if A1 is a partial Text of any cell ( One or more) in the same Column, I want to put "1" in the cells Beside for both the partially matched and the cells matched with it, 0 if not match.

Then

IF A2 partially match any text in all the column $A, I put "2" for both the partially matched and the cells matched with it, 0 if not.
and So on ...3 4 5 ... etc.


Thanks in Advance

 

[Chihiro]

Cross post - http://www.excelforum.com/excel-pro...ba-for-partial-match-in-the-same-coulumn.html

Read below.
http://forum.chandoo.org/link-forums/new-users-please-read.17/

 

[Marc L]

So as a wild cross posting, I'm away …

OP must read this !
​