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

Maybe you can use the attached.

Attached Files

PivotTest_4.xlsx (28.8 KB, 11 views)

xor

Brilliant, you have been exceptionally helpful and I appreciate it.

I am learning so much about Excel and it's hidden capabilities (to most people anyway).

Having used it for many years, I have never got passed the basic table stage and although I knew there was much more to it, because I have not really needed it until now, I have not bothered to learn the more advanced features.

Thank you once again.

Rob