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
Glory
10 months agoAntonette
10 months agoJamal
10 months agoShizue
10 months agoGlory
10 months agoJamal
12 months agoDeonna
1 years agoLai
1 years agoValentine
1 years agoLeota
1 years agoCammy
11 months agoJeff
11 months agoJonelle
11 months agoMirta
1 years agoTimothy
1 years ago