Could you please post a small sample sheet with some data and expected results?



OTOH would a Pivot Table help?

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Here is a sample

ID Day Date Country City Venue Capacity Sold Fee % Gross Net Note
1 Thurs 19/10/2016 Norway Oslo Oslo Concert Hall 1200
2 Fri 20/10/2016 Sweden Malmo Malmo Live 2300
3 Sat 21/10/2016 Sweden Stockholm Cirkus* 2200
4 Sun 22/10/2016 Germany Bonn Beethovenhalle 5000
5 Fri 29/10/2016 England Buxton Opera House 975
6 Sat 30/10/2016 England Salford The Lowry 2200



I have been playing with pivot tables and have managed to come up with some fairly useful ones. What I can't work out at the moment, is how to show the last date we visited a certain venue. I have been trying to filter this info but not much luck at the moment.

Thanks, Rob