MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Need formula to match two Ranges

Posted by Tonya on April 22, 2001 9:23 PM

I need a formula that will compare text in two separate Ranges and find
those that match.

Thanks for your help!


Posted by Steve W on April 22, 2001 9:36 PM

Hi tonya
have you tryed the match function and maybe also use conditional formating to highlight match.

Posted by Dave Hawley on April 23, 2001 4:24 AM

Hi Tonya

There are many ways to do this in Excel, here is one. It assumes your lists are in Column A and Column B. In C1 put this formula:
Copy thi sdown as far as needed

I also have some examples of highlighting and preventing duplicates on my Website under the link "Handy Hints".


OzGrid Business Applications