Thursday, January 9, 2014

yogi_Highlight Data That Is In Column B But Not In A with Red BackGround And Data That Is In Both B And A With Green BackGround

                                          Google Spreadsheet   Post  #1480
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Jan-09-2014
question by Sebatian Segura (!category-topic/docs/spreadsheets/UXJjax7QHSA)
Compare data on columns
Hi all, if anyone can help me with this case thank you much

I have to find if the data on column A mach with the data of another column.

For example, in columnn A I have a list of numbers and in column B of another listing, I need to know if the data in column B are in column A and if not, identify what data in column B was not found

Thank you.
as of Jan-08-2014 I have noticed there is a problem displaying Google New Sheets in my blog posts

so in case my spreadsheet is not being displayed in the blog post, I am posting an image of the spreadsheet  as well