Last seen: Jan 16, 2025
Riny, As always totally in awe of your ability, thanks so much. Regards Paul
Riny, Works perfectly. Thanks
Riny, Thank you so much, you are indeed a Gentleman and Scholar. I see what you mean by a bit ugly; and yes I am on an old Excel version. However...
Almost have it, just need to exclude anything after 365 Days =COUNTIFS(Personnel Names Column,Individuals Name Cell, Dates Column, "<="&...
Riny, My humblest apologise' and it is I that must thank you for your patience, I uploaded the wrong file (again I will blame age, for lack of...
Hi Hans, Thanks for that; and it may be a possible option but as I've been working with it I realised that I could unprotect sections (I've done th...
Hi Riny, I've highlighted the anomalies; If you look at the 'owssvr Active Courses' worksheet you will see that I16 and J16 are within a day ...
Hi Riny, Apologies; I had to cut significant pieces out to make it small enough to load. Specifics: Source Worksheet 'owssvr Active...
NO NEED TO ADVISE - LEFT HERE AS A MATTER OF INTEREST - ISSUE RESOLVED (Just made the default in their SharePoint List default as 0 for the relevant c...
Hi Hans, Yes I've solved it an I know there is data missing, I was too big to upload, I am trying to set them up with a systerm that will run throu...