Many thanks XOR

I have successfully transferred the formulas to the proper table and it has worked a treat, almost!

The information now shows the last date of every visit we have made in the last 20 years.

How do I now filter that information so that I can select just one Country, or the UK (4) or Australia for example.

I also want to sift out only those entries in Note2 that match certain criteria, ie Yes, Poss, Good etc. I don't want the Overseas and No entries to show in this particular list, but I might next month.

I found this worked well in the pivot Table.

Is it a case of using a pivot table for some columns and then bringing in the formulas in other columns to get them right.

Thanks

Rob