Hi,
Column A = Customer Names (many duplicate entries, because of column B)
Column B = Customer Location (all customers have multiple locations)
Column C = "type1" or "type2"
a customer might have "type1" and "type2" locations
How do we make a formula, for column D, to state if the customer has both types?
something like: "IF Customer Name Has "type1" AND "type2" then say "MIXED" else say "NOT MIXED"
thanks
data would look like:
CustomerAB | 555 street | type1 | mixed
CustomerAB | 500 street | type2 | mixed
CustomerXZ | 111 street | type1 | not mixed
CustomerXZ | 089 street | type1 | not mixed
Column A = Customer Names (many duplicate entries, because of column B)
Column B = Customer Location (all customers have multiple locations)
Column C = "type1" or "type2"
a customer might have "type1" and "type2" locations
How do we make a formula, for column D, to state if the customer has both types?
something like: "IF Customer Name Has "type1" AND "type2" then say "MIXED" else say "NOT MIXED"
thanks
data would look like:
CustomerAB | 555 street | type1 | mixed
CustomerAB | 500 street | type2 | mixed
CustomerXZ | 111 street | type1 | not mixed
CustomerXZ | 089 street | type1 | not mixed