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!

Tonya
terton@earthlink.net


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.
steve

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:
=IF(COUNTIF(B:B,A1)>0,A1,"")
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".


Dave


OzGrid Business Applications