title: Extract unique combinations from Excel sheets
body: <p>I am looking for a way to extract all unique combinations from a number of Excel sheets with multiple columns. E.g.:</p>
  
  <pre><code>#no.   | fruit    | city    | year    | something else
  1      | apple    | London  | 2015    | some text
  2      | banana   | London  | 1999    | no text
  3      | apple    | Oxford  | 1895    | some text
  4      | banana   | London  | 1999    | no text
  </code></pre>
  
  <p>How can I get a list of all unique rows (except for column 1 of course) with any function in Excel or VBA? Preferably it is a script-like way, because the sheets contain over 6000 rows of varying information. </p>
  
  <p>Any thoughts?</p>