Thank you so much, sir.
One addition, we can concatenate a space with Text(B1), Text(B2),.............. also, like
so that when B1 is a substring of A1 or A2 or any of them, that doesn't count.
if A1 has a value 67 and B1 has a value 6, that'll be counted as a match, but it shouldn't be. Adding a space at the end of B columns solves that.
I hope you understood what i meant. I'm sorry if I couldn't explain properly.
Thanks a lot for answering and solving my problem. Made my day.