title: Removing duplicates of a 2D array in VBA
body: <p>I have found lots of methods to remove duplicates of a 1D array but could not find a 2D example. 
  In addition to that, I wonder if the fuction can "leave" an instance of the duplicate item instead of removing them all. </p>
  
  <p>Is it possible to do it?</p>
  
  <p>Example:</p>
  
  <pre><code>Sub Tests()
  
  Dim Example()
  
  Example(0,0) = "Apple"
  Example(1,0) = "Apple"
  Example(0,1) = "Pear"
  Example(1,1) = "Orange"
  
  End Sub 
  </code></pre>
  
  <p>Remaining items would be: <code>Apple, Pear and Orange</code></p>