title: Excel (Mac) Formula - Group Like Items and Search Each Row
body: <p>I've got a really huge excel file (14mb) that I need to remove certain rows based on criteria and can't figure out what the formula would look like to accomplish what I need.</p>
  <p>Here's an example of the data:</p>
  <pre><code>ID             TYPE          MATCH
  12345          CAR            
  12345          TRUCK
  54321          PLANE
  54321          BOAT
  12345          BOAT
  </code></pre>
  <p>For this example, what I need to do is group all duplicative IDs and then search through each of the rows of that group to see if one of them is a car.</p>
  <p>The output should look like this:</p>
  <pre><code>ID             TYPE          MATCH
  12345          CAR           TRUE  
  12345          TRUCK         TRUE
  54321          PLANE         FALSE
  54321          BOAT          FALSE
  12345          BOAT          TRUE
  </code></pre>
  <p>Since ID 12345 has a car in the group, all of those rows get marked as true. Likewise, as 54321 does not have a car in the group, all of those rows get marked as false.</p>
  <p>I want to do this entirely using a formula as I need to modify the search parameters to pair down the data.</p>