title: List of comma separated values in Excel cells to unique list of values and count
body: <p>I have a list of countries separated by commas down 1 column.  I need to create a unique/distinct list of the countries and a count of how many times they appear as outlined in the picture.  Currently doing this via manual efforts and looking for a much quicker way.  Open to VBA but prefer formulas if possible.  Thanks!</p>
  
  <p><a href="https://i.stack.imgur.com/HSv16.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/HSv16.jpg" alt="Example image"></a></p>