title: Google Sheets - compare 2 (4) columns
body: <p>This has to be simpler than it seems. I have 100 rows. Col A is registration status, let's say &quot;Registered&quot;. Col B is the person's email address. Cols C and D are pulled from Outlook's calendar tracking, which gives their email in Col C, and their reply, let's say &quot;Accepted&quot;, in col D.</p>
  <p>The issue is, many who have accepted the invite haven't registered for the event. Or they've registered but haven't accepted. etc etc.</p>
  <p>EDIT: Forgot to add, Cols A and C <em>ARE NOT ORDERED THE SAME</em>. Col A has the 100 people actually invited, Col C has people that aren't. Simply put, way too much effort to fix that.</p>
  <p>I need a way to find all the discrepancies. Thanks so much!!</p>
  <p>EDIT2 - sample spreadsheet <a href="https://docs.google.com/spreadsheets/d/1BU4Z6YQlvm1VqIbfq131muh6ElJqHR5wGDMwson-g8s/edit?usp=sharing" rel="nofollow noreferrer">https://docs.google.com/spreadsheets/d/1BU4Z6YQlvm1VqIbfq131muh6ElJqHR5wGDMwson-g8s/edit?usp=sharing</a></p>
  <p>I want to see that - for example - Deb accepted the calendar invite (col D) despite not registering for the event (col A). That's a discrepancy I'd need to investigate.</p>