Hi!
I'm trying to figure out a smart way of comparing text strings in two columns and returning the values that are unique for column B in column C. The order of the values is random and superfluous commas and spaces need to be removed (no commas occur within the individual values).
All help is greatly appreciated!
<tbody>
</tbody>
I'm trying to figure out a smart way of comparing text strings in two columns and returning the values that are unique for column B in column C. The order of the values is random and superfluous commas and spaces need to be removed (no commas occur within the individual values).
All help is greatly appreciated!
A | B | C |
chocolate, strawberry | banana, chocolate, strawberry | banana |
vanilla, blueberry | licorice, raspberry, vanilla, fudge, blueberry | licorice, raspberry, fudge |
<tbody>
</tbody>