title: Dynamic Named Range for Dropdown: Removing Duplicates without VBA
body: <p>I am creating an Excel dashboard that I want to be as "hands-off" as possible.</p>
  
  <p>Users paste in an exported .csv report that looks like the below, can have up to tens of thousands of rows:</p>
  
  <pre><code>Company     Property    Segment Type    Date        Forecast
  Company 1   Property 1  Transient       01/01/2016  395.6599731
  Company 1   Property 1  Corporate       01/01/2016  5066.720295
  Company 1   Property 2  Transient       01/01/2016  4671.060322
  Company 1   Property 2  Corporate       01/01/2016  0
  Company 1   Property 1  Transient       02/01/2016  3513.280067
  Company 1   Property 1  Corporate       02/01/2016  3513.280067
  Company 1   Property 2  Transient       02/01/2016  0
  Company 1   Property 2  Corporate       02/01/2016  3180.830109
  Company 2   Property 1  Transient       01/01/2016  3180.830109
  Company 2   Property 1  Corporate       01/01/2016  749.5098877
  Company 2   Property 2  Transient       01/01/2016  3104.579819
  Company 2   Property 2  Corporate       01/01/2016  2355.069931
  Company 2   Property 1  Transient       02/01/2016  602.5899658
  Company 2   Property 1  Corporate       02/01/2016  3327.980011
  Company 2   Property 2  Transient       02/01/2016  2725.390045
  Company 2   Property 2  Corporate       02/01/2016  0
  </code></pre>
  
  <p>There will be a separate tab containing a Company dropdown list, a Property dropdown list, and Average Forecast displays.</p>
  
  <p>I've got multiple dynamic named ranges as follows (sample is for Companies):</p>
  
  <p>=OFFSET(Data!$A$2, 0, 0, COUNTA(Data!$A:$A)-1, 1)</p>
  
  <p>I want to have dropdowns that do not contain duplicates, so just Company 1, Company 2.</p>
  
  <p>When I use the dynamic named range above, the dropdown has 8 Company 1s and 8 Company 2s.</p>
  
  <p>Any way to do this without using VBA?  Can Array functions be nested within Dynamic Named Ranges?</p>