displaying missing data with a formula
 

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.

displaying missing data with a formula
 

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

"Shu of AZ" wrote in message
...
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.