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     www.energyefficientbuild.com.   Nov-19-2014

post by WhoSoLovesUs:
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/7j5trQMRGaM)
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:

https://docs.google.com/spreadsheets/d/1QC4FBD303_REjJbA3K7oXouvbPNRM8sMtfkWxlpd8qk/edit?usp=sharing

------------------------------------------------------------------------------------