150 cars and finding the top 10

http://@DMHutchhttps://www.priceusedcar.com/

Here's how you can calculate the top 10 cars from your list of 150 cars in Excel:

1. First, make sure your data is organized in columns with headers such as "Category" (Classics, Stock, Rods/Modified, Special Interest, Pickups) and "Car Name" (the name of each car).

2. Assuming your data starts from cell A2 (A1 being the header for "Category"), you can use the following formula to rank the cars within each category:

   • For Classics (assuming "Classics" is in column A and car names in column B):

     excel

     =IF(A2="Classics", RANK(B2, B$2:B$151, 0), "")

   • For Stock (assuming "Stock" is in column A and car names in column B):

     excel

     =IF(A2="Stock", RANK(B2, B$2:B$151, 0), "")

   • Repeat the same pattern for Rods/Modified, Special Interest, and Pickups.

3. Drag the formula down for all 150 cars.

4. Now, you'll have rankings for each category. Next, you can use the LARGE function to find the top 2 cars in each category. For example, for Classics:

   excel

   =LARGE(range_for_classics_rankings, 1) =LARGE(range_for_classics_rankings, 2)

   Replace "range_for_classics_rankings" with the actual range of rankings for Classics.

5. Repeat the LARGE function for Stock, Rods/Modified, Special Interest, and Pickups to find the top 2 cars in each category.

6. Finally, combine all the results to get the top 10 cars overall.

This process should give you the top 10 cars based on their rankings within each category. Let me know if you need further clarification or assistance with any step!