Wednesday, February 15, 2012

yogi_Mark Items in LIST1 That Are In LIST2

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                  

user jveix33 said:
Compare Column B to Column A, Highlight Duplicates
I am working on two different databases with some overlapping data. Currently I have two columns, Column A has a list of everything, and Column B contains a list of things I've already added from Column A. So basically I was wondering if anyone could help me find a way to compare column B to column A and highlight the duplicates in column A therefore I can see clearly what I still have to add. The Problem I've been having is that each column has a different number of items and this was giving me trouble developing a formula.
following is a solution to the problem