title: Excel formula/VBA to get unique values of two columns
body: <p>For the following data in excel, I want to retrieve the unique pairs via Formula/VBA. Can someone please suggest a solution?</p>
  
  <pre><code>NAME    RESULT
  atest   PASS
  atest   PASS
  atest   PASS
  atest   FAIL
  atest   PASS
  btest   PASS
  btest   PASS
  btest   PASS
  </code></pre>
  
  <p>The output should like follows.</p>
  
  <pre><code>NAME    RESULT
  atest   PASS
  atest   FAIL
  btest   PASS
  </code></pre>