Filtering a range of cells, based on another range

Maybe a few ways to go about this.

1) In 2007 there is a function built into the ribbon which will remove duplicates...

Data >> Data Tools >> Remove Duplicates

Take one list and paste it below the other list and then run the option above...

2) Again, combine the two list and then use the Advanced Filter...

3) Use the match function to see what is different. Once you copy the formula in B2 and copy down, all those that match List2 will have a number and those not matching will show #N/A. Filter column B by the #N/A and delete.

B2 copied down >> =MATCH(A2,$C$2:$C$4,0)

Data Range

	A	B	C
1	List1	Match	List2
2	Jan	1	Jan
3	Feb	#N/A	Mar
4	Mar	2	May
5	Apr	#N/A
6	May	3