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