Hold up, wait a minute. Isn't INDEXC different from INDEX? I thought INDEX just checks if the string contains the substring, not whether the entire string is valid.
Yeah, that's how I understood it too. I think the best way to do that would be to use the INDEXC function, which checks if the string contains any characters that are not in the specified character set.
Hmm, this question seems pretty straightforward. I'm guessing the valid values for TRT are 'A', 'B', and 'C', and we need to find the invalid ones, right?
upvoted 0 times
...
Log in to Pass4Success
Sign in:
Report Comment
Is the comment made by USERNAME spam or abusive?
Commenting
In order to participate in the comments you need to be logged-in.
You can sign-up or
login
Deonna
10 days agoLai
12 days agoValentine
13 days agoLeota
15 days agoMirta
17 days agoTimothy
18 days ago