Thursday, April 6, 2017

yogi_List In Column C Items That Are In Column A and NOT In B And Those That Are In B But NOT In A

Google Spreadsheet   Post  #2144
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Apr-05-2017
question by Dominic Ng:
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/EtH811d42PE;context-place=forum/docs
Comparing Two Columns and Returning in Third
Hi,

I have a question about how to write a formula that compares two columns (i.e. Column A and B) of string data and returns the string data in the third column where if the data is matched BETWEEN A and B, ignore it but if they show up in A and not B and show up in B but not A, I'd like those strings returned. 

Is this possible to do it in 1 column or maybe even 2 at max? Thanks!