List Compare

Two lists of anything - email addresses, SKUs, file names, user IDs - and the answer to which ones overlap, which went missing, and which turned up twice.

List A

List B

How to read them

Split each list on

Matching Trim spaces from both ends Ignore upper and lower case Skip blank entries Sort the results

Overlap

only in A in both only in B

Result

Paste two lists to compare.