Search and code
Closed
Ireh666
Posts
2
Registration date
Friday 28 July 2017
Status
Member
Last seen
28 July 2017
-
28 Jul 2017 à 04:05
stankirsolkar Posts 6 Registration date Friday 28 July 2017 Status Member Last seen 31 July 2017 - 28 Jul 2017 à 23:20
stankirsolkar Posts 6 Registration date Friday 28 July 2017 Status Member Last seen 31 July 2017 - 28 Jul 2017 à 23:20
Related:
- Search and code
- Yahoo search history - Guide
- Spybot search and destroy - Download - Antivirus
- Cs 1.6 code - Guide
- Google search from usa - Guide
- Vim search - Guide
2 responses
stankirsolkar
Posts
6
Registration date
Friday 28 July 2017
Status
Member
Last seen
31 July 2017
28 Jul 2017 à 11:53
28 Jul 2017 à 11:53
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'."
28 Jul 2017 à 18:19
28 Jul 2017 à 23:20
So the formula becomes: =IF(ISNUMBER(FIND(B10,$H$12)),1,"")