how to match case sensitive words in excel

**genetist** · 07-04-2013, 03:25 AM

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

**dilipandey** · 07-04-2013, 03:35 AM

Hi Genetist,

You can use "Find" function, see attached:-

Formula:

=IF(ISNUMBER(FIND($B$1,$A$7:$A$10)),"Yes","no")

case sensitive.xlsx

Regards,
DILIPandey
<click on below * if this helps>

**XOR LX** · 07-04-2013, 03:36 AM

Hi,

=IF(EXACT("Bf3Bf3",A1),"Yes","No")

Copy down as required.

Regards

how to match case sensitive words in excel

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

how to match case sensitive words in excel

Re: how to match case sensitive words in excel

Re: how to match case sensitive words in excel

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions