Two values to find on the same cell
Solved/Closed
jutulu
Posts
34
Registration date
Monday March 10, 2014
Status
Member
Last seen
September 21, 2015
-
Apr 1, 2014 at 01:51 PM
jutulu Posts 34 Registration date Monday March 10, 2014 Status Member Last seen September 21, 2015 - Apr 7, 2014 at 04:06 PM
jutulu Posts 34 Registration date Monday March 10, 2014 Status Member Last seen September 21, 2015 - Apr 7, 2014 at 04:06 PM
Related:
- Based on the values in cells b77 b81
- Based on the values in cells b77 b81 which function can automatically return the value - Best answers
- Based on the values in cells b77:b81 - Best answers
- Pate values - Office Software Forum
- Return Seq Values Until Blank value then return different set of seq values ✓ - Excel Forum
- Name Values - Excel Forum
- Add values based on query - Office Software Forum
- How to change account based in instagram - Instagram Forum
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
Apr 7, 2014 at 12:01 PM
Apr 7, 2014 at 12:01 PM
Hi Jutulu,
So you basically want to know if either "(dr)" or "(ba)" are present in E2180 (you are not counting).
Another way to get that result is to use:
=IF(OR(ISNUMBER(SEARCH("(dr)",E2180)),ISNUMBER(SEARCH("(ba)",E2180))),1,"")
Which is 6 characters shorter (or 4 if you want to put the 1 on the left side of the cell).
To answer your question: YES
Best regards,
Trowa
So you basically want to know if either "(dr)" or "(ba)" are present in E2180 (you are not counting).
Another way to get that result is to use:
=IF(OR(ISNUMBER(SEARCH("(dr)",E2180)),ISNUMBER(SEARCH("(ba)",E2180))),1,"")
Which is 6 characters shorter (or 4 if you want to put the 1 on the left side of the cell).
To answer your question: YES
Best regards,
Trowa
jutulu
Posts
34
Registration date
Monday March 10, 2014
Status
Member
Last seen
September 21, 2015
2
Apr 7, 2014 at 04:06 PM
Apr 7, 2014 at 04:06 PM
Thanks. It works great
