Forum Discussion
150 cars and finding the top 10
Love to help, but you need to help us help you.
What is the basis for determining "Top"? Are there votes for each of the entries? Some other quantitative or qualitative ratings associated with each of the 150 entries.
In other words, what's the nature of the database that has been dumped on you?
Importantly, is it something you can share? Or, if the actual database is private (at least until the time comes to reveal those winners) could you at least post a sample with actual identifying details blocked off, but with all of the fields that would be used to determine "top"? You are not likely to be able to post that file here in the forum but you can post it on any of the cloud services (OneDrive, Google Drive, or something else in that category), and then post a link here, and make sure you've granted access.
In the absence though of your answering some of the questions I've asked, there's not a lot of help that can be given. You need to give us an idea of what you're working with.
Thank you for your response.
People vote on their favorite Classic car. The car is numbered 100.
Each time the car is voted on it is counted. The car with the most votes wins that category.
No names are listed. Based on the car entry number and how many votes it gets in that category. There are 5 categories as listed before and each category has 2 winners determined by the number of votes. Total of 10 cars winning.
- Share a sample workbook and show your desired output.
