title: How to exclude records in excel that have specific attributes
body: <p>I have a long list of email addresses in an excel sheet where the emails are in column A and I have colors in column B. For instance, see table:</p>
  
  <pre><code>   EMAIL                     COLOR
  1. test@example.com          red
  2. test@example.com          blue
  3. testing123@example.com    blue
  4. testing123@example.com    blue
  5. testtest@example.com      red
  6. testtest@example.com      blue
  </code></pre>
  
  <p>I can't figure out how to filter out or remove any email address that is associated with the color red without doing this manually (I have thousands of rows of data, so this isn't happening).</p>
  
  <p>So in this case, the only email address I want to eventually import into my email program is testing123@example.com. Imagine there are thousands of rows like this - is there a conditional formula for column C that can lookup this relationship and provide a "true/false" flag for each email record?</p>