I have data in two cells that is comma separated. I want to compare the values in these cells without copying them to new cells if possible.
So if I have list of names, say,
Cell A1: Person X, Person Y
Cell A2: Person Y, Person X
I want the comparison to return that the values are equal...