Excel formula question.
Closed
marengl1
Posts
1
Registration date
Tuesday June 7, 2016
Status
Member
Last seen
June 7, 2016
-
Jun 7, 2016 at 01:41 PM
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 - Jun 8, 2016 at 10:18 AM
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 - Jun 8, 2016 at 10:18 AM
Related:
- Excel formula question.
- Excel grade formula - Guide
- Number to words in excel formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Credit summation formula - Guide
1 response
xpcman
Posts
19528
Registration date
Wednesday October 8, 2008
Status
Contributor
Last seen
June 15, 2019
1,824
Jun 7, 2016 at 04:01 PM
Jun 7, 2016 at 04:01 PM
ISNUMBER checks to see if the value is a number - not a text match.
Jun 7, 2016 at 05:44 PM
didn't know if it matter but I even tried ISTEXT got worst :))
Thanks for your time.
Jun 7, 2016 at 10:42 PM
Jun 8, 2016 at 08:40 AM
Not to forget that my cell info look like this:
EC ; CRA ; FO ; RCMP ; NATRES ; IAND
So I think there is no answer to this due to the limitation of the word SEARCH.
not sure if in excel there is another word that can isolate each word and be able to do a better triage.
Thanks for your time Ray.
Appreciated.
Luc:)
Jun 8, 2016 at 10:18 AM
I found a similar question here and while it does not actually solve your problem regarding ND vs IAND if does offer a slightly different solution using array formulas and look-up lists.
.
Can the values ND or IAND be changed to something unique as this would solve the problem immediately?
Could ND and IAND be in the same cell or are these mutually exclusive?
I'll have another look and see if I can come up with anything else.