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...

...	...	DROP DOWN LIST

<tbody>
</tbody>

TITLE	NAME OF ISSUE	OCCURRENCES

<tbody>
</tbody>

 

[oldbrewer]

When the same selection has been selected multiple times,

can you explain this in more detail please