Forum Discussion
Chaplain Visits Per Shift
Greetings, I need a formula that extracts from column F, Visits to Patients Per Shift, and represent that result in a pie chart and a bar graph. Column F describes the date and time of each Chapl...
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
- If it works on a MacBook Pro using macOS Monterey, I will get the subscription to Microsoft 365.
- It does. I'm on an iMac at the moment, on the Ventura OS -- another update I'd recommend.