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
- Based on the values in cells b77 b81 - Best answers
- Based on the value in cells b77 - Best answers
- Excel macro to create new sheet based on value in cells - Guide
- Compare 2 text cells and show difference in the third cell ✓ - Excel Forum
- Auto serial number in excel based on another column ✓ - Excel Forum
- Based on the values in cells b77 b81 - Office Software Forum
- Conversion of values already present in cells ✓ - Excel Forum
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
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