title: Excel Highlight Duplicates and Filter by color alternative
body: <p>My spreadsheet has about 800,000 rows with 30 columns. Customers are interested in duplicate values only in one column. They need the entire row back. For e.g.</p>
  
  <pre><code>MemberId|Name|Address|CircleScore
  H111|John Doe|123 W Main|2.4
  H222|Jane Doe|124 W Main|3.2
  H333|Bob Doe|125 W Main|2.5
  H444|Jake Doe|126 W Main|2.1
  H555|Mike Doe|127 W Main|2.4
  </code></pre>
  
  <p>They want the entire rows where there are duplicates in CircleScore. So my filtered excel should only contain:</p>
  
  <pre><code>MemberId|Name|Address|CircleScore
  H111|John Doe|123 W Main|2.4
  H555|Mike Doe|127 W Main|2.4
  </code></pre>
  
  <p>I tried highlighting duplicate CircleScore and filtering, but the filtering part takes for ever.  I have waited for 15 minutes but still no luck. The duplicates could be around 150k.</p>
  
  <p>Is there an alternative?</p>