Compare lists and highlight matches
Hi,
I'm looking for a way to compare two lists (they're quite extensive) and highlight the matches. Is there a formula for this? thanx S. |
Compare lists and highlight matches
One way using Conditional Formatting, with the two lists in columns A and B,
in column A use CF, Formula is =COUNTIF($B$1:$B$5000,A1)0 and in column B =COUNTIF($A$1:$A$5000,B1)0 and set the formatting to turn the cell red or whatever, Regards, Alan. "srain001" wrote in message ... Hi, I'm looking for a way to compare two lists (they're quite extensive) and highlight the matches. Is there a formula for this? thanx S. |
Compare lists and highlight matches
Maybe look at the MATCH function? MATCH returns a number showing the
relative position of a matched value, or else a #N/A error. Those values for which MATCH returns a number, therefore, are matched to the list you are matching against. Post back if you have questions. Dave -- A hint to posters: Specific, detailed questions are more likely to be answered than questions that provide no detail about your problem. "srain001" wrote: Hi, I'm looking for a way to compare two lists (they're quite extensive) and highlight the matches. Is there a formula for this? thanx S. |
All times are GMT +1. The time now is 04:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com