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
stankirsolkar Posts 6 Registration date Friday July 28, 2017 Status Member Last seen July 31, 2017 - Jul 28, 2017 at 11:20 PM
Related:
- Search and code
- Battery reset code - Guide
- Samsung volume increase code - Guide
- Cs 1.6 code - Guide
- How to get whatsapp verification code online - Guide
- Nokia factory reset code forgot - Guide
2 responses
stankirsolkar
Posts
6
Registration date
Friday July 28, 2017
Status
Member
Last seen
July 31, 2017
Jul 28, 2017 at 11:53 AM
Jul 28, 2017 at 11:53 AM
Use the following formula:
=IF(ISNUMBER(SEARCH(B10,$H$12)),1,"")
=IF(ISNUMBER(SEARCH(B10,$H$12)),1,"")
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'."
"My user typed in 'aCtive', but I was looking for 'Active'."
Jul 28, 2017 at 06:19 PM
Jul 28, 2017 at 11:20 PM
So the formula becomes: =IF(ISNUMBER(FIND(B10,$H$12)),1,"")