Creating a tally chart

[t1o9n9y1]

I am trying to create a tally chart.

I have a spreadsheet with a drop down list containing roughly 30 different selections.
When the same selection has been selected multiple times, I ideally want them tallied in
a separate table on the same sheet. The top 5. I want the name of the selection to be copied
over as well as tallying the amount of occurrences. Is this possible?

The spreadsheet looks like this...
[TABLE="width: 500"]
<tbody>[TR]
[TD]...[/TD]
[TD]...[/TD]
[TD]DROP DOWN LIST[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 500"]
<tbody>[TR]
[TD]TITLE[/TD]
[TD]NAME OF ISSUE[/TD]
[TD]OCCURRENCES[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[oldbrewer]

When the same selection has been selected multiple times,

can you explain this in more detail please