title: How to extract a distinct list of records from SQL or Excel
body: <p>I have an excel spreadsheet with 15 columns, one of which is EmailAddress and then 100,000+ records.. </p>
  
  <p>In my data i know that there are many duplicate email addresses.</p>
  
  <p>Can someone tell me how can i extract a distinct list where each record is represented only once by emailaddress?</p>
  
  <p>Alternately, if i import the data into SQL, how can i remove records that are duplicated by emailaddress but leave one record if 4 are found...</p>
  
  <p>Thx..</p>