Hi to all,
I have some problem to match case sensitive letters in excel with match function, my data looks like this
Bf3Bf3 Bf4Bf4
Bf3bf3 Bf4Bf4
Bf3bf3 Bf4Bf4
Bf3bf3 Bf3bf3
i want to search Bf3Bf3 down the column it if eaxctly macth to Bf3BF3 not for bf3Bf3 or Bf3bf3 then yes else no
i want output like this
Bf3Bf3 Bf4Bf4 yes yes
Bf3bf3 Bf4Bf4 no yes
bf3Bf3 Bf4Bf4 no yes
Bf3bf3 Bf4bf4 no no

i want to found exact letter i mean not case sensitive, help will be apreciated
Thanks