displaying missing data with a formula

  • Thread starter Thread starter Shu of AZ
  • Start date Start date
S

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.
 
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
 
Back
Top