I obtained a formula from www.cpearson.com for extracting values on one list
and not another.

I put 16717 rows of part numbers in cells A2:A16717. I put another list of
part numbers in cells B2:B16717.

I entered the formula =IF(COUNTIF($A$2:$A$16717,B2)=0,B2,"") into cell C2
and used the fill corner to enter the formula in C cells down to C16717.
(which it the one from the web site)

Shouldnt I be getting the values that on on the B cell list but not in the A
cell list?
Seems like I was, ( had to keep putting new numbers in the B cell list over
and over to get a new extracted list in C cells - needed to sort over 60,000
part numbers against A cell list ) Then I noticed I was getting alot of
duplicate numbers and blank cells in the extracted list.

Also had another problem, some of the part numbers are the same in A cell
list and B cell list and shouldnt show up in the extracted list but they are
due to a key entry.
Example:
dm-002-03 in Acell list
DM-002-03 in Bcell list

Anyway to overcome these problems?

Thanks Bunches,
Barbara