Comparing data from 2 colums

I have a worksheet with a list of names in column A and a list of names in column B. Most of the names are the same, but there are some additional names in column B.

What I need to do, is to identify/isolate the names that are in Column B, but not column A.

How can I do this?

Thanks.

hi,

try this

put this in the conditional format in column a and b and paste down



=COUNTIF($A$1:$b$100,b1)>1

steve

Originally Posted by stevekirk

hi,

try this

put this in the conditional format in column a and b and paste down



=COUNTIF($A$1:$b$100,b1)>1

steve

Can you elaborate on this a little? I've never used conditional formatting, so I'm not really sure where to paste this formula.

Originally Posted by VBA Noob

Link should help

http://www.cpearson.com/excel/ListFunctions.aspx

VBA Noob

You can also use a formula to extract elements that exist in one list but not in another. Again, it is assumed that you have two named ranges, List1 and List2 of the same size. Create a new named range called In1Not2 the same size as List1. The following formula is an array formula that must be entered into an array of cells. Select the In1Not2 range, type in the formula and press CTRL SHIFT ENTER.

=IF(ISERROR(MATCH(List1,List2,0)),List1,"")

This formula will return the elements in List1 that do not appear in List2. Select the cells in which you want the results to appear (this should be the same size and List1) type the formula and then press CTRL SHIFT ENTER.

The order of the elements in the result list correspond to the position of that element in List1.


-------------

This is the one I want to do. I think I'm missing something with the lists. It seems like I have to do something more than just titling the column List1 or List2.