Hello,
We have two columns [say C1 and C2] which contain names. We need to display the names in Column C2 that are not present in column C1.
ex: C1 [Name 1, Name 2]
C2 [ Name 0, Name 1, Name 2, Name 3, Name 4 ...]
The result should show contents of C2 as Name 0, Name 3, Name 4 ...]
Tried using set expression, concat and match options, but none seems to work. It should be an easy task, but could not find any relevant info so far.
Please do share the possible solution if available.