Comparing lists

[paalley]

I have a spreadsheet with a master list of products in column A.
In column B I have a partial list. I need to compare Column A and Column B and get a listing of all of the products from the master list that is not listed in column B. Can this be done with conditional formating of with an if statement? I don't know anything about using VBA code. Any help would be appreciated. I just need to compare the partial list to the master list and find out the ones that are not on the partial list.

 

[acw]

Hi

In A1 go Format, Conditional Format, Formula Is, =COUNTIF($B:$B,A1)=0, select your format option, OK.

Copy the cell, then paste the formats to the relevant cells in column A.

It should highlight entries in Column A that are not in column B.


Tony

 

[scu77]

deleted

 

[paalley]

What do you mean by paste the formats to the relevant cells

 

[paalley]

Comparing Lists

How do you paste the formats to the relevant cells ?

 

[acw]

Hi

Once you have put in the conditional format for A1 as above, then select A1, copy.

Highlight the rest of column A starting in A2 for the range you want to paste the formats (say A2:A40), then edit, pastespecial, formats.


Tony