Macro to Display the Top 5 Most Frequently Occurring Part Numbers

[Hackboss007]

Hi everyone!

I'd like to create a macro to display the top 5 most frequently occurring repairs on sheet 3 of my workbook. I'd like the macro to analyse all the sheets in my workbook except for the first 3 and then output the results on the 3rd sheet from T50 onward. I have attached a template as an example of how all the sheets in the workbook look (excluding the first 3). All the sheets have the same layout as the "Survey Template" worksheet.The repairs are located under the Log Book Review of Historical Structural Repair in the Survey Template worksheet and all the repairs are picked through a drop down list that is based on a table of repairs listed in the Parts and Prices sheet within the workbook. I have assigned random serial numbers to the repairs (if that makes it any easier to code instead of locating exact string matches). Any help would be greatly appreciated. Thanks!

Best wishes,
Hackboss007

[ragulduy]

Hi,

I've attached an example of how I would do this as a formula approach.

[Hackboss007]

Hi ragulduy!

I was able to get a working macro to find the most frequently occurring repairs in terms of serial numbers. I then used Vlookup from the table to display the repairs corresponding to the highest occurrences. Thanks though.

Best wishes,
Hackboss007