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 what function can automatically
- What function can automatically return the value in cell b77 - Best answers
- Based on the cell values in cells b77 - Best answers
- Based on the values in cells b77 b88 ✓ - Excel Forum
- Based on the values in cells b77 b81 what function can automatically return the value in cell c77 ✓ - Excel Forum
- Looking For a Value in a Cell - Excel Forum
- Conditional Formatting range of date cells based on another cell ✓ - Excel Forum
- Download automatically while roaming - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Contributor
Last seen
December 27, 2022
555
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
