This formula of your works but I have to have a seperate column to get the
common entries, how do I do it so that I just highlight the common entries in
parent column (as I need to know their order (ranking) number)

Thanks for your inout