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