Previous Topic Next Topic

Search and code

Closed
Ireh666 Posts 2 Registration date Friday July 28, 2017 Status Member Last seen July 28, 2017 - Jul 28, 2017 at 04:05 AM
stankirsolkar Posts 6 Registration date Friday July 28, 2017 Status Member Last seen July 31, 2017 - Jul 28, 2017 at 11:20 PM
Hello, so I have this problem in excel where I need to compare the words that are in a certain cell and compare them to the separated word if it finds the word in the combined field it will put 1 in the specific field. so basically, the formula would run through B:G and H is the combined words that are needed to be looked upon B:G


http://static.ccm2.net/ccm.net/pictures/AYAHxuhUpYqBMk0TjuguVuE3Kkl7HOFov78EOZABPYmjYqAYwO0ihppAKu6jpLcI-capture21.png

2 responses

Answer 1 / 2
stankirsolkar Posts 6 Registration date Friday July 28, 2017 Status Member Last seen July 31, 2017
Jul 28, 2017 at 11:53 AM
Use the following formula:
=IF(ISNUMBER(SEARCH(B10,$H$12)),1,"")
0
Ireh666 Posts 2 Registration date Friday July 28, 2017 Status Member Last seen July 28, 2017
Jul 28, 2017 at 06:19 PM
Hello stan, this looks awesome but it would be more awesome if it's case sensitive. if it isnt too much to ask :D
0
stankirsolkar Posts 6 Registration date Friday July 28, 2017 Status Member Last seen July 31, 2017 > Ireh666 Posts 2 Registration date Friday July 28, 2017 Status Member Last seen July 28, 2017
Jul 28, 2017 at 11:20 PM
If you want this to be case sensitive, use FIND instead of SEARCH.

So the formula becomes: =IF(ISNUMBER(FIND(B10,$H$12)),1,"")
0
Answer 2 / 2
Blocked Profile
Jul 28, 2017 at 09:49 PM
If you wish to have case sensitive, it is already there. You do understand that case sensitive means that "that" and "thaT" are two different things? Why limit your string matches to HOW the user types. You will end up with the following result:

"My user typed in 'aCtive', but I was looking for 'Active'."



0

Similar discussions

lava hard reset & factory reset
AVAY -
Har -

3 responses