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