Forum Discussion
I need to count how many times 2 different letters appear in a column & totals in diff. cells
We all begin somewhere, some time. I happen to have begun working with databases and arrays back in the early 1970s....and have been an Excel junkie ever since it came out. Retired in 2002 (I'm 78 yrs old) and now am having fun answering questions like yours here on this message board.
Anyway, if what I sent looks useful, I'd be happy to work to make it a bit more elegant.... and even personalize it for you.
- Well thank you for helping me because I have been trying to figure this out for 2 days now! I think I understand it. Not 100% sure if I do I did add a name and date and day or night. The question I have is does that list just keep going? Just curious if I open another workbook or sheet for each month? Currently I have the same workbook exactly like the one I sent you but for March. We have been informed we will be on this assignment at least until June but most likely until September! The other question I have is I am using another workbook for tracking anyone that is deployed and becomes sick I have to identify who they were with so I can put all them on quarantine. That is another thing I have been working on but didn't know if it can all be incorporated in one. I really want to thank you for helping me.
I'm actually not expecting you to understand all that I've done here. But yes, to your question, the list will just keep going. That's the thing about a database. And NO, you won't need to add a new sheet for a new month. That's another thing about a database. The reporting can be tailored to whatever timeframe you wish.
So I've been playing around a bit myself as you'll see on the attached. I've gone away from the Pivot Table to the newest technology that Microsoft has introduced just in the last year...ARRAY formulas. Just been learning them over the last week or two.
I added a column here to make it easier to select a week--this column determines a week number (e.g. the 14th week of the year)--and does it automatically based on the date you enter. Then to create a report, you just enter the start date of the week (I'm assuming Sundays for that)....and it automatically adjusts for that week.
And as you add rows to the database....it captures them and reports them for the corresponding week.
Now: I can help you create a drop down list of names for each center and then, for each center, a specific list of names of the people who are deployed in that center. You could update it from there, so it always was current.
Why don't you email me a list of the actual names of your Agencies....I'll create dummy lists for you to complete of the actual names of the real people....
As for the quarantine cases, it probably makes sense to track those on a separate sheet. It could be part of the same workbook, just so all of your records are in the same place.
And you'll be off and running for the next week and the rest of the year.
mathetesI can attach the names of the agencies or just a list of them or I can send you a copy of the workbook I am using which each tab has the agency name and the agency people that have been sent so far for deployment it is only last names used if there are the same last name there is just first initial. the tab with command is the staff in the operations center.
I don't know if that is ok?
I have been playing around with the book you have sent me and I know it can be done but not sure how, but can there be like more freedom as to the fact that it will auto complete items such as year and etc.?
Please let me know
Thank you,
I think this will be awesome!!!