- COMPARING TWO COLUMNS OF NAMES IN EXCEL
- When chevy is first name of boy then second name will be matching which one?
- How to carry out compare two lists in excel
- Comparing two columns of names in Excel
- Compare values in two columns and return the value from third (Solved)
- Comparing two lists of names in Excel and then sorting them
- Excel - Comparing two columns A&B
- Excel - Compare two columns and delete duplicates

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.