It's preferable to post an actual Excel sheet. You can do this by clicking Go Advanced.



At any rate, I have attached one that determines last date played for each venue using a pivot table. I added another date for Malmo to illustrate it. To do this, just get Max of Date.

Lots of ways to skin this cat though.

A few things:

* I had to change the date formats above to the silly American m/d/yyyy so don't let that confuse you.
* The day of the week data are somewhat superfluous as that can be shown in the Date field. Just choose the appropriate formatting.

Attached Files

Gigs.xlsx (14.0 KB, 16 views)

Sorry, I am new to this depth with Excel. How do I go Advanced?

Thanks gebobs, that is exactly one of the things I am looking for. I have been playing around with it using filters etc.

We have played in over 260 different venues all with different names. However some of these are in different cities and, indeed, different countries. so, New Theatre, could be in Oxford, Blackpool or Sydney, Australia.

What I can't quite work out is how to get a report with three columns, venue, city, date (Last Played)

I have filtered out the countries I don't want, but I can't get past the City in a row above the venue and then a city total beneath that.

I have actually got rid of the subtotals but I want a 3 column answer rather than 2 rows. Is there a way to do this?