I just want to make a comparison if Column B value contain in Column A. For example if cell B1 = Ahmad Azman Bin Ahmad Saud which Ahman Azman Ahmad Saud does contain in cell A1 so column C1 should be True
Hi Narayan,
Its in one cell both Column A and Column B.
I want column C to return the matching names from Column B and check in the whole column of A .
Thanks for your quick respond.
Regards,
Kasthuri.
Hi ,
I need help on finding the matching values.
Column A - Tan Ai Ling
Column B - Ai Ling Tan
Column C should return the matching names - Ai Ling Tan.
What formula should I use for this. HOpe you can help me. Thanks.