You may need 2 formulas in 2 separate columns to get unique items when comparing 2 lists.

in C1, =IF(ISNA(MATCH($A1,$B$1:$B$100,0)),$A1,"") copied down

in D1, =IF(ISNA(MATCH($B1,$A$1:$A$100,0)),$B1,"") copied down

The first lists the elements in A that are not in B and the second lists the elements in B that are not in A...

adjust the ranges to suit.

__________________
Where there is a will there are many ways. Finding one that works for you is the challenge!

Please read the Forum Rules: Rules