Forum Discussion
I need to count how many times 2 different letters appear in a column & totals in diff. cells
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!!!
Downstate
Eastern
Fishkill
Green Haven
Otisville
Shawangunk
Sullivan
Ulster
Wallkill
Woodbourne
Auburn
Cayuga
Elmira
5 Points
Mohawk
Coxsackie
Oneida
Southport
Command
- mathetesMay 21, 2020Gold Contributor
To send a private message, you click on the person's name at the top of one of a posting. Doing that takes you to the person's "Profile" page, and up at the top right corner you'll see a "Message" block.
- peteryac60May 21, 2020Iron Contributor
You guys are having great fun - so I won't interfere!
But I note that you said you sent a private message. Can you tell me how to do that please? many thanks,
- lagearedApr 16, 2020Copper ContributorThat would be cool also! I just sent you a private message also.
- mathetesApr 16, 2020Gold Contributor
It occurred to me that it might be a lot more functional for an attendance tracker if the names of the people were in alphabetical order by last names, and fortunately that kind of thing is very easy. So this version works that way.
I'm sure you'll also want to revise the report format, or add additional capabilities--e.g., showing two, three or even four weeks in succession. That can be done. Let's do a few revisions along those lines before you start filling in the actual names. You can plan to start using this for your May tallies, at the very latest. If we work fast, maybe by this coming week.
- mathetesApr 15, 2020Gold Contributor
Here you go. I've included a few instructional boxes, and certainly stand ready to help with any questions.
I'll send a private message as well which you'll be able to get through that little envelope icon in the upper right of this screen.
- lagearedApr 15, 2020Copper ContributorFire Response Protection detail for Correctional Facilities