- How to compare names in excel
- Compare names in excel in two columns
- Compare for matches in first and last name when in two columns
- Comparing two columns of names in Excel
- Comparing two lists of names in Excel and then sorting them
- Excel - Comparing two columns A&B
- Excel - Compare two columns and delete duplicates
- Excel - Comparing two columns

This worked great as a very fast audit of 2 rows of text. Just type in the formula and filter by "false" to find the discrepancies. Amazing tip!

Yes! I have tried SO many different "solutions" this finally did it. I had a long column A, a short column B and was able to remove any appearing in A that also appeared in B. So simple and yet so complicated. Thanks!

Hi STEMPEKA,

I see that this thread status is "not resolved".

You will find here an other way to solve your problem without using macro or formula :

http://ccm.net/faq/sujet-5278-how-to-compare-two-workbooks-worksheets

I hope this helps

Marc

I see that this thread status is "not resolved".

You will find here an other way to solve your problem without using macro or formula :

http://ccm.net/faq/sujet-5278-how-to-compare-two-workbooks-worksheets

I hope this helps

Marc

Members get more answers than anonymous users.

Being a member gives you detailed monitoring of your requests.

Being a member gives you additional options.