progress

Hi there - what I thought maybe simple but I cannot find an answer! I need a bar chart with the various work items along the side, i.e. WORKITEM_1, WORKITEM_2, WORKITEM_3 etc. Along the bottom of the chart I need to have the various stages (these need to be words, and not a percentage of its...

I am looking for an excel formula to identify the latest stage of a project. <tbody> A B C D E F G H I J 1 Progress Stages 2 Project Prepare Start 30% 60% 90% Complete Stage 3 Battersby 21/09/2018 22/09/2018 15/12/2018 30% 4 Phillips...

Hey All- I believe I am looking for a simple index match function based on two criteria, but I must be missing something basic (typically rely on vlookups). I want to return the ticket number for a specific NPI that the Patient Services team is working on. The intent is to combine this weekly...

<tbody> Colleague TEAM Course id 123 Course id 124 Course id 125 Course id 126 Course id 127 Course id 128 Colleague 1 TEAM A Successful Successful Successful Successful Successful Successful Colleague 2 TEAM B In Progress In Progress Not Registered Successful...

Hi Mr. Excel Users, I need to compute the turn around time below. Note: There is no way to change the way that they extract the data from server. Condition: 1. There are hundred thousands of duplicate "Case Number", perhaps thousands of unique Cases. 2. I need to calculate the turn around...

Hi, I have a list of items, with various status (open, closed, in progress, accepted ...) I also have a ' Last Actioned' date. I want to display a number which is a count of items with a subset of the status's (ie, "Open" and "In Progress" AND which have a last actioned date which is older...

Hi all, I'm having trouble figuring out a formula in excel, and was hoping someone may be able to assist. I have data for a number of people and the status of their work in another column. Essentially want to calculate an overall status. If they have atleast one work complete in 2018, then...

Hello Everyone, Would it be possible to create a circular progress bar? I'm well aware of creating a progress bar using form and label but I'm not sure it is feasible to do it in excel 2016 and display it in the userform.

I'm currently using the formula below to count the # of "In Progress" (column M) projects where the SI = 40500 (column K) and the deployment date is equal to / greater than 2018 (column N). However, the "In Progress" has been split into 4 different areas that still equate to being In Progress. I...

Hi all, i need a progress indicator so that to appears on screen the percentage till end of any code which i run. Note that i cannot create the "User Form" and so if is possible to create it too. Thanks in advance

Hi, I have two tables, in two seperate worksheets. I will refer to them as table and table 2. In table one I have a reference number in col A and a value (%) which i would like to show in col B. Table 1 <tbody> Reference % Progress 1 2 3 4 </tbody> In Table 2 I have a unique...

Column A = "Status". Values: Unassigned, In Progress, Rejected, Not Proceeding and Complete Column B = "Date Closed". Values: Date I need a statement where I get a 1 value when all the following conditions are met: 1. Date Closed is not blank AND 2. Status = "In Progress" OR "Unassigned"

Hi all - thanks for your time and expertise. I'm considering using Excel to update the way my team provides monthly updates to the boss. I imagine having a shared workbook with a worksheet for each month of the year. Each row will refer to a task assigned to the ten staff in my work area...

Hi All, i have below recorded macro which is running fine and my data are accurate. i am calling all the macro in a below sequence. just wanted to check if i can add any progress bar to check the progress of the macro. Sub EveryThing() Call Macro3 Call test Call Macro1 Call...

Hello, I was poking around trying to find some code to create a pop up progress meter when a large spreadsheet i have exceeds say 30 seconds. The file is large with many array formulas and a full file calculation can exceed 3 hours. I was looking for a visual indicator to show me what's going...

At my company we currently use an google sheet to track the progress of installations in progress, Installers have access and enter times manually. We have also recently created a Word Form that is essentially checklist of these same points for installers to follow and keep them on track. I was...

Hi all, I have 3 macros called : RegGenerate AreaGenerate ZoneGenerate then i want to make 1 module to run all this 3 macros, using "For", you might ask why? this is because i want to use progress bar to inform user, what macros that currently going my current on going code is like this, i...

Morning, I'm looking for suggestions to achieve the following situation: We are having a charity bike rid from John O Grote's to Lands End on a stationary bike. We would like to display the progress from the bike ride on a TV from Excel. So a value of miles done will be entered regularly be it...

Hello all, Working on a new type of code for creating a Userform Progress Bar. Never done anything like this before so bare with me. I found this article on the web as a start to create the userform and bar visually - http://www.excel-easy.com/vba/examples/progress-indicator.html And it was...

Hi, is it possible to create conditional formatting of icon set as an indicator of task status, i.e. if an action is "in progress", i want to show a yellow circle icon next to "in progress", if an action is "completed", i want to show a green circle icon next to it. The icon set currently in...