Wednesday, November 19, 2014

yogi_From Entries In Site1 And Site2 Find Those In Site1 (and not is site2) In Site2 (and not in site1) and Common To Both Site1 and Site2

                Google Spreadsheet   Post  #1838
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Nov-19-2014
post by WhoSoLovesUs:
Compare two sheets and display the rows that are not found in the other?
I have two sheets that will have some rows of data in common

What I'm trying to see is the rows that are found on sheet1 but not sheet2

I've tried messing around with QUERY function but haven't got it figured out yet

Just looking at one column at this point (D)

Thanks! :)
PS - I know people like to see spreadsheets, here is a public one that anyone can edit: