title: How to keep only the LAST value of each pair in excel VBA?
body: <pre><code>Contract No Price
  D/019/09    17.85
  D/019/09    17.85
  D/019/09    17.85
  D/019/09    17.85
  D/023/09    17.85
  D/023/09    17.85
  D/026/09    0
  D/026/09    0
  D/038/11    20.6
  D/038/11    20.6
  D/038/11    20.6
  </code></pre>
  
  <p>The above is an example data series ... and I will like to keep just the LAST occurence of each unique contract no. In the above example, I would like to only keep D/023/09 17.85, D/026/09 0 and D/038/11 20.6. So there should only be 3 unique values. What is the most efficient way to do it?</p>