compare 2 lists and highlight repeated combinations

  • Thread starter Thread starter eagerowl
  • Start date Start date
E

eagerowl

2 columns. 2 lists. compare combinations from both lists and highligh
repeated combinations from both lists. example of combinations:
2 4 6
5 8 11
etc
 
Sounds like a straight MATCH() function...

Something like -- well let's assume the first list on
sheet one a set of unique combos running down the A column.

Next, some list of combo's in A column of Sheet2 and you
want to see if they match anything in Sheet1?

In cell B2 of Sheet2, put the formula:

=MATCH(A2,Sheet1!A:A,0)

This looks for the exact match and returns the row it
found it on Sheet1 or #N/A if no match.

Excel Support Technician
www.canhelpyou.com
-----------------------------------------------------------
 
Back
Top