Search results

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...

Thanks for the ideas. I will try them in the next few days.

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...

uploading file ugh..no option to even upload a file on this thread..please delete this

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.

Thanks for the help, Luke.

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...

Hi, The uploaded file is fine. The colored cells work nice. The icons are desired to help others as some believe colored cells is too much color.

Hi, I am trying to use conditional formatting to do two separate actions: 1) color the cells either red, yellow, or green, and 2) use the red, yellow, and green stoplight icons This will allow the user to choose which view they want to use. This is using percentages as follows: cell G1 is the...

Hi, I have a few questions about slicers. 1) Is there a way to quickly scroll thru a long list in a slicer? I have one slicer that has over 100 options and I have to scroll thru them all to find the one I want. Of course, I can always go to multiple columns to solve the issue but if I want...

Thanks for the welcome & the username / passowrd help. And, right...what am I asking for? :) I want to get h3 & i3, and yes, you are correct..a simple vlookup will do that, and then I can multiply those results with a regular old multiplication formula in k3. What I would like to do is...

Hi, 1st, I had enrolled previously but could not remember my user name, my password, nor could I find the email sent to me with that info. So, I created a new user name in the belief I would be notified that the email address was already in use, my new registration would be stopped, and I...