I like your chart and I am going to attempt to duplicate it. Could you also provide the instructions in case I am unsuccessful?
However, what I was envisioning is below. Is my idea possible?
Job #
Planned Work Percent
Start
End
Note
Job #1
5%
1/1/2021
12/31/2021
Job #2
20%
1/1/2021...
Hi,
I don't know why but I am having difficulty even getting started on this task.
I was asked to chart an employee's planned work effort against the employee's actual work effort over an entire year. As an example, employee A states they have the following planned work effort. There are 40...
Hi,
I am looking for ideas on how best to present the following data:
over 200 employees
6 different degree types: HS; GED; Associates; Bachelors; Masters; PHD
47 different fields (of study): Accounting; Biology; Math; etc.
I plan on showing a bar chart that details number of degrees...
Hi,
I have a list of employees with their job level and years in their job level.
I would like to rank each employee within their job level, with the longest in their job level being the highest ranked, and each job level's ranking starts where the previous job level ranking ended, meaning some...
HI, Thanks for the reply. Yep, that is the issue.
However, why is Excel not doing this automatically as it has in the past?
I use the subtotal button on the Data menu and in the past I just keep using that button to nest subtotals, and never have to manually make a change to the...
Hi,
I have done this so many times in the past it is second nature. However, for some reason I am now having an issue. Is it me? Am I forgetting a step?
I have 135 employees assigned to 4 groups, and the 4 groups are further subdivided down into 15 different organizations.
I sorted the...
with a slash
L / AW
AW / AA if a person was at work in the morning and then gone in the afternoon
AW / BT if a person was at work in the morning and then leaves for a business trip
S / AW if a person was sick in the morning but then eventually rose from their deathbed and made...
Good Morning,
Yes, the 1st scenario is working great. I can confirm that it is what I needed. THANKS!
Medical is extended absence like for surgeries, accidents, etc., something that is going to have you out of work for medical reasons for more than 3 consecutive work (M-F) days.
Sick is...
Any progress on my scenario #2? I believe I can combine the status's that use the same color but I am unsure of how to even start the formula to use for the conditional formatting. Can one of you give me a hint so I can try and then get back to you? Thanks.
Hi,
1st, I appreciate the help. I continuously have difficulties with conditional formatting. And, match & index, but that is for another post. Today, my issue is with conditional formatting. Here are the 2 scenarios:
1) a 3-column Excel 2010 spreadsheet: A) Name and B) Expiration Date and...
SirJB7, thanks for the reply. I had already used the absolute value in my formulas and that was not the issue. I just had not used the absolute value in the thread when I wrote it. However, Narayan did use it in his solution. It works as desired. I am hoping the stop lights solution is...