title: How to find and pull out duplicate text fields in Excel
body: <p>I have about 80,000 emails in one column of MS Excel 2010.</p>
  
  <p>Some of them are duplicates and I need to find and pull those duplicates. I want the duplicates in a separate document.</p>
  
  <p>Right now I can find them and highlight them in red using the Conditional Formatting function that's built right into Excel (Home tab > conditional formatting > Highlight Cell Rules > Duplicate Values) but that literally just highlights them.</p>
  
  <p>There's also Remove Duplicates, which obviously just deletes them; Not what I want either.</p>
  
  <p>Any suggestions?</p>