Forum Discussion
Grouping maybe? But how?
I have a database that has a column (B) called partners with seven companies listed sporadically throughout based off the row lines. I need to create a column (G) for Affiliations and create a functio...
If you want to avoid a mapping table, although I discourage you to do so, your formula in G2, copied down rows, would be:
="Group "&
IF(OR(B2={"Aone","Atwo","Athree","Afour"}),
"A","B")
Note that the names in the logical1 argument of OR are assumed.