Forum Discussion
Solved
Conditional format for Alpha-numerical Columns
I have a column with alphanumerical values identifying the difference between INTERNAL versus EXTERNAL contact. A B MUST1234 EXTERNAL HAVENO INTERNAL NOHAV12 EXTERNAL ...
if List.ContainsAny(Text.ToList([A]), {"1","2","3","4","5","6","7","8","9","0"}) or [A] = "GLAMRO" then "EXTERNAL" else "INTERNAL"
What is I want to make an exception to the rule to capture one or two of the descriptions that does not have a value as part of the description and call it "External".
Example "
A | B |
MUST1234 | EXTERNAL |
HAVENO | INTERNAL |
NOHAV12 | EXTERNAL |
MITE1233 | EXTERNAL |
GLAMRO | External |
FAMINW | INTERNAL |
if List.ContainsAny(Text.ToList([A]), {"1","2","3","4","5","6","7","8","9","0"}) or [A] = "GLAMRO" then "EXTERNAL" else "INTERNAL"