Biff

I selected C1 and presses key combo of CTRL,SHIFT,ENTER, but was unable to
paste in the formula.

"Biff" wrote:

Hi!

Column A1:A19 = secondary list
Column B1:B19 = master list

In C1 enter this formula with the key combo of
CTRL,SHIFT,ENTER:

=IF(ISERROR(SMALL(IF(COUNTIF(A$1:A$19,B$1:B$19)=0, ROW
($1:$19)),ROW(1:1))),"",INDEX(B$1:B$19,SMALL(IF(CO UNTIF
(A$1:A$19,B$1:B$19)=0,ROW($1:$19)),ROW(1:1))))

Copy down until you get "blanks".

Will return:

C1 = 12A221332
C2 = 12A221333
C3 = blank

Biff

-----Original Message-----
If I have a master list of 20 part numbers in one Excel
column or worksheet
how can I compare each part numbers in the master column
against actual
values/part numbers in another column or worksheet, and
highlight in red the
missing parts in a third column? Is there a wizzard to
help me or will I have
to write a complicated macro or loop?
.