title: How to select distinct values from one column in adodb recordset Excel VBA?
body: <p>I have a <code>ADODB.Recordset rs</code> that I'm getting from DB. I have to reuse this recordset twice now.</p>
  
  <p>This is sample of my Recordset:</p>
  
  <pre><code>Mike     Client
  John     Manager
  Karen    Client
  Joe      Sub
  Brian    Manager
  </code></pre>
  
  <p>Now I need to get all the titles, so I want to get:</p>
  
  <pre><code>Client
  Manager
  Sub
  </code></pre>
  
  <p>I know that there is <code>rs.Filter</code>, but I'm not sure if I can select distinct from it.</p>
  
  <p>Also I know that I can clone this Recordset:</p>
  
  <pre><code>Dim rs_clone As ADODB.Recordset
  Set rs_clone = New ADODB.Recordset
  rs_clone = rs.getrows()
  </code></pre>
  
  <p>Is it possible to clone only distinct records? Or any better way? Thanks</p>