Let's say Column A has a, b, c, d, e, and f. Column B has a, c, d, and f. I want column C to show that b and e are missing. On a much larger scale that I'd rather not have to scroll through a whole bunch of N/As or blanks to find the few bits of real missing data (Only 7 or 8 things, out of 1000+, should be missing in column B from column A.)

Sorry if that doesn't make sense.