Forum Discussion
150 cars and finding the top 10
I need help We have 150 car entries. I need a formula to calculate the top 10 cars. Top 2 cars in category Classics Top 2 cars in category STOCK Top 2 cars in category RODS/MODIFIED Top 2 c...
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.