title: Best way to filter and find unique values two times in vba?
body: <p>I'm looking to find a way to find the unique values of column 1 and find the unique items in column 2 that corresponds to each item in column 1 so I can map the "higher level" stuff the "lower level" stuff. </p>
  
  <p>For example, the excel sheet would look like this </p>
  
  <pre><code>Column 1         Column 2          Column 3 
  New York         Brooklyn          ....more information about col 2 
  New York         Manhattan 
  New York         Staten Island 
  New York         Queens 
  New York         Bronx 
  New Jersey       Newark 
  New Jersey       Jersey City 
  New Jersey       Edison 
  CT               Hartford 
  CT               Windsor 
  </code></pre>
  
  <p>I would have to gather Brooklyn, Manhttan, Staten Island, Queens and Bronx when New York is chosen. (I am making a listbox so that when New York is selected, the above boroughs show up on the second listbox but I can't figure out how to grab the borough information when the user specifies the State is NY. I need a way for excel to search through the excel sheet until it finds New York and then looks at the cells next to column with New York) </p>
  
  <p>What is the best way to do this and how will I actually do it?  Dictionary, collections, for loop, autofilter? </p>