This seemed to work! Thanks Jack!

Well C is the first group in the list (relative to date) ... hence number 1. Similarly for B and D, they are the second and third "distinct" groups over...

First off, apologies for not providing a "real" data set - I can understand how that would get annoying 🙂 So here is a second shot at my "real" data:

CREATE...

No it doesn't ... just the data. The field names are provided in another file on their website. However, it seems after some more laborious searching and messing around I...