Hi!

Copy/Paste the formula into cell C1.

The formula will appear in the Formula Bar.

Goto the Formula Bar and place the cursor at the end of
the formula.

Hold down the CTRL key and the SHIFT key then hit ENTER.

If done properly Excel will enclose the formula in
squiggly braces { } which means that it is an array
formula. You must use the key combo of CTRL,SHIFT,ENTER
for it to work. You can not just simply type the braces in.

Biff

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


.