displaying missing data with a formula

[Shu of AZ]

I have three cols

red green missing
blue yellow missing
green brown missing
white
yellow
brown

How do I compare the second col with the first col to display the missing
data in the 3rd col which should read red, blue, white.

 

[Bernie Deitrick]

Shu,

Array enter (enter using Ctrl-Shift-Enter) this formula in C1:

=INDEX($A$1:$A$6,LARGE(ISERROR(MATCH($A$1:$A$6,$B$1:$B$3,FALSE))*ROW($A$1:$A$6),ROW(A1)))

and copy down to C2:C3.

HTH,
Bernie
MS Excel MVP