Forum Discussion
Chaplain Visits Per Shift
Those are real names, I believe. That's a file that you should take down immediately (per site policy for protecting privacy). Post files only with false names.
- click on the three dots in the top left corner of your post, select Edit...that will then allow you to delete that attached file. Put it back with false names (or no names, if you're not needing this summary by name)
- Thank you!
This is by no means a finished summary, but I wanted to check to see if it's even in the right direction. What is in the attached is a summary by day of the number of reports filed by shift. It no doubt would be more meaningful if we reduced it to by month by shift, but, as I said, it's a start.
Also not the most elegant formula, and I'm afraid it uses the most recent version of Excel, which may render it inaccessible to you, now that I think of it. Are you not in a position to update your software? There are some VERY useful functions in Excel 2021 or a subscription to Microsoft 365