Forum Discussion
DMHutch
Sep 14, 2022Copper Contributor
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...
DexterG_III
Sep 15, 2022Iron Contributor
DMHutch Hey DM, I'm attaching a very basic template that will hopefully get what you need. If you copy your data into the table with Category/Entry/Vote Tally (columns B:D), the formulas will expand to include all the entries. It doesn't matter if you need to copy more data than what's there as long as the end result contains the three headers mentioned above.
Then there's a summary to the right of the table that ranks the cars using most votes. You'll need to determine how to break the tie if you have 3 cars in a given category all with the same number of winning votes.
Hope this helps get you started,
Dexter