StudentofExcel
New Member
- Joined
- Dec 2, 2017
- Messages
- 7
Hello All,
If some come can point me to right resources I would appreciate it.
My problem is that I would like to create function =QC() that returns "Good" or "Bad".
And I would use it to check all "code numbers" if they have less then 6 character to return text "Bad" next to a cell. If first two caracthers are not: "10,20,30,40,50,60,70,80,90" it should return "Bad", if next two caracthers (3rd & 4th) are not: "AA,BB,CC,DD,EE,FF,GG,RR" return "Bad", if next two caracthers (5th & 6th) are not: "11,22,33,44,55,66,77,88,99" return bad, if "Code number" is "Good" but it does contain anywhere in code number: "Err","Error","EER" it should return "Bad".
Example
A (Code numbers) B
10CC22 Good
10CC22Err Bad
11CC22 Bad
30RR44 Good
30RR4 Bad
The function would be located in B2 and it would be based on A2, I would drag it to the end of a column of B. =QC(A2)
If someone could help I would very appreciate it.
Best regards,
Jenan
If some come can point me to right resources I would appreciate it.
My problem is that I would like to create function =QC() that returns "Good" or "Bad".
And I would use it to check all "code numbers" if they have less then 6 character to return text "Bad" next to a cell. If first two caracthers are not: "10,20,30,40,50,60,70,80,90" it should return "Bad", if next two caracthers (3rd & 4th) are not: "AA,BB,CC,DD,EE,FF,GG,RR" return "Bad", if next two caracthers (5th & 6th) are not: "11,22,33,44,55,66,77,88,99" return bad, if "Code number" is "Good" but it does contain anywhere in code number: "Err","Error","EER" it should return "Bad".
Example
A (Code numbers) B
10CC22 Good
10CC22Err Bad
11CC22 Bad
30RR44 Good
30RR4 Bad
The function would be located in B2 and it would be based on A2, I would drag it to the end of a column of B. =QC(A2)
If someone could help I would very appreciate it.
Best regards,
Jenan