Compare lists and highlight matches

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
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
 
Back
Top