I need a formula to find outliers in columns A and B. Basically, we are looking at long lists of names that (in theory) are supposed to match. We are essentially cross checking two databases and making sure our customers are in both lists. Sometimes they only show up in one column or database, and I would like to find the outliers without having scroll through 1000 or so names and looking for extras. Is there a formula that can help me?
Solved by Z. H. in 20 mins