View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Shu of AZ Shu of AZ is offline
external usenet poster
 
Posts: 130
Default 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.