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