title: Find the most frequent but weighted values in Excel for a voting system calculator
body: <p>I'm looking to create a voting system calculator, by taking a list of people's preferences (1st to 5th preference), and automatically find the most popular ones, but by giving weight to the place of the user's preference.
  i.e 1st Preference gets 5 points, 2nd Preference gets 4 points, 3rd preference gets 3 points etc.
  Then add up the points values, and show the top 6 most popular ones based on this voting system.</p>
  <p>I have followed <a href="https://www.exceldemy.com/find-most-frequent-numbers-excel/" rel="nofollow noreferrer">this post</a> for the most frequent numbers... but it's the weighting/boosting of values that I'm missing out on.
  In my example, I will only have 4 or 5 people voting, and I have roughly 25 possible values.... so for now, the alphabet works pretty well. Here is an example of the results that I'm after.
  <a href="https://i.stack.imgur.com/VEd2X.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/VEd2X.png" alt="Voting System example" /></a></p>
  <p>*The results show the aggregate points of the most popular preferences, and the most popular preferences themselves in the two rows.
  Now I manually figured out these results in a separate two columns on the side, but ideally I just get this all within the cells V3 to AA4...if that's possible, however I'm open to any better alternatives.</p>
  <p>Here's my manual column calculation list to show how I know the preferences:-</p>
  <p><a href="https://i.stack.imgur.com/Q5QHm.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Q5QHm.png" alt="Manual Voting List" /></a></p>