- How to match names in excel where names spelling same
- How to match two names with same name in excel
- Find the same name in 2 different excel 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/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/5278-how-to-compare-two-workbooks-worksheets

I hope this helps

Marc

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.