LinkBack URL
About LinkBacks
I know there's a trick I am missing....
Trying to insert a column for a calculated field - I would like to see - on a particular day, by route # or number of employee names, if there is more than 1 of either per day
I know there's a trick I am missing....
Trying to insert a column for a calculated field - I would like to see - on a particular day, by route # or number of employee names, if there is more than 1 of either per day
Last edited by BDD2015; 03-08-2018 at 01:05 PM.
.
It would be best to post a simulated workbook of your project. Do not include confidential information. It is difficult to determine what you are dealing with without actually seeing it first.
Hi, again Logit
Thought I did. Here we go again. Thanks as usual.
If I understand the intent correctly then the attached file may help.
1) Row labels are: Name, Date, Route
2) Value is count of employees
3) Report layout is tabular
4) Subtotals and Grand totals are not needed
5) The formula that populates column G (which is just a range, as opposed to a calculated field):Formula:
Please Login or Register to view this content.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
Awesome. That will definitely do it JeteMc. But just for the sake of my head, do you know what I was doing wrong with the CF or why it wasn't working?
Appreciate your help, as always!!
You're Welcome and thank you for the feedback. As to "why" I believe that you were thinking Excel should count the number of employees per date per route, whereas Excel was calculating whether or not the text string for the employee (i.e. Marc Ewing) > 1. Please take a moment to mark the thread as 'Solved' using the thread tools link in the ribbon above your first post. I hope that you have a blessed day.
This may be closer to what you originally had in mind.
Above and beyond! Thank you!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks