Forum Discussion
Chaplain Visits Per Shift
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
Well, then, I am not sure. I'd be surprised if it doesn't still work. I also have an old MacBook Air, and Microsoft 365 does work on it. Even works on my iPad.
In any event, I've updated that initial attempt to report by month. Here's what the summary looks like. File attached.
Formulae are still less than fully elegant. I suspect SUMPRODUCT might be the more elegant solution, but I've never been able to fully figure that one out. This could be my opportunity.
Actually, come to think of it, with the data revised as I've done it, a Pivot Table would be all you'd need--no formulas at all, except in the derivation of the shift number--and a graph can easily be derived from that.
- My Mac will not update to Ventura OS. I'm using MacBook Pro / macOS Monterey version 12.6.5.
- It does. I'm on an iMac at the moment, on the Ventura OS -- another update I'd recommend.