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)