Table of instances occurred

Apologies in advance if this makes people cringe I would consider myself a noob when it comes to excel.

Context: I have an excel spreadsheet of every concert I’ve ever been to, date/location/event/band/support etc.

How would I go about making a table that tells me, for example; top 5/10 bands I’ve seen and *the number* so that it will update if I input more data along the line.

Again apologies if this is the wrong place to ask or has any of you banging your head against a wall because it’s that easy but it would be greatly appreciated if anyone could help.

Thanks :)

Edit: This is the headings of each list

Date
Event
Venue
Location
Band/Artist
Supports/Features
Guestlist