title: VBA Dictionary for uniqueness count
body: <p>I am in need of a macro that finds all the unique names in a list and then counts them. I then need to display them on another excel page.</p>
  
  <p>After reading up on it I think the best way to do this is with a Dictionary? But after several attempts myself I cant seem to crack it.</p>
  
  <p>Example list:
  - Apple
  - Orange
  - Banana
  - Banana
  - Orange
  - Pear</p>
  
  <p>Output would be:
  Apple     1
  Orange    2
  Banana    2
  Pear      1</p>