Counting the entire cell content to another cell

[Sekars]

Hello Friends

I need to count the entire cell contents (From Column A) to partial cell content (Column E).

I need the expected result hardcored in Cells Column G light yellow cells by formula.

thanks in advance

[shukla.ankur281190]

Try

G2=SUMPRODUCT(--(MID(E2,ROW(INDIRECT("1:"&LEN(E2))),1)=A2)) and drag down!

[Sekars]

Hello Ankur

Thanks for your formula which is working well.

Just now i myself G2=COUNTIF(E2,"*"&A2&"*") and drag down!

Thanks again