Macro to work out top 3 cell occurances

[Guacamoley]

Hi everyone.

I have a database full of part numbers for example [TABLE="width: 185"]
<TBODY>[TR]
[TD]0EV2310A06G01JU:S5065</SPAN>
[/TD]
[/TR]
</TBODY>[/TABLE]

These can vary to having a vareity of symbols/letters/numbers (I am not sure if this makes a difference!)

I am looking for help to writing a macro to run a report to show the top three reoccuring partnumbers.

The spreadsheet is currently 1845 cells big but this data will change on a weekly basis, the layout will however remain the same. The column that the part numbers are in is column A.

Would anyone be able to recommend a solution? Is a macro the right way to be approaching this if the data is going to be changing on a weekly basis?

I hope that you can help

 

[nuked]

Pivot Table

 

[Guacamoley]

Thank you so much nuked!!