completed

Hi! :) First time posting so i apologize in advance if i don't explain the issue i am having as well i should. I have been asked to create a spreadsheet with gantt chart for the purpose of monitoring the status of a project. I've been told to keep it simple with the inclusion of a few visual...

Hi I have an issue where I want to count complete months where all days count in the month. For example if you look at the difference between 2 dates, so 01/01/19 minus 01/01/19 we get 0, but say I want to say someone attended a course on that day, they in fact completed 1 day. So I want the...

Hello Everyone, I am new to Excel and need some help for my project. I want to extract a particular cell value on weekly basis. The start and end date of project is known. The cell value named 'percentage of work completed' updates every day, but I want to know the status only on weekly basis...

this will be a major help but i'm not sure if anybody can help me. I have a massive data sheet that i would like to sort out. I dump the raw data on sheet two and would like to type in the item i want to see the history on in sheet one. example below sheet two then sheet one. <tbody> ticket...

In Sheet 1 I have Column P = WIP Column R = Testing Column Z = Completed In Sheet 2, from L164 downwards I have dates, 1/4/19,8/4/19, 15/4/19 etc What I need is to count the number of occurances of each inthat week So, Order | W.I.P. | Testing | Completed 100001|1/4/19|10/4/19|14/4/19|...

I have a bunch of dates down column E (Due Dates). And I have a bunch of dates down column F (Completion Dates) I am trying to create a CountIfs formulas that would show How many were completed on time and how many were completed late between two date (example 10/1/2018 and 10/31/2018) Or...

Good Morning, I have this formula to give me the percentage completed by count of project =COUNTA(L5:L10)/COUNTA(B5:B10) but what i need is that if in L5:10 have the words "Completed to give me the percentage only when the words completed are in the cell and not to count any other words in the cell

Hi everyone, It is my first time using this service so hoping I will find the answer I need... I got this table named TableTimeData: OPP Number [Project: Created Date] [Site Visit - Completed Date] 0001 11/01/2018...

Hi All. I simply want to create a drop down list with data validation The list comes from a tab that is from name manager. It is A3-A7,,, the list being; NOT STARTED IN PROGRESS AWATING REPLY COMPLETED After the word COMPLETED is a cell with nothing in it. When I go to insert the list (via...

I need to calculate throughput by quarter for a project, based on units created. For example: There 432 total widgets needed; 22 widgets can be completed a week; how many widgets can be completed by quarter until all 432 widgets are done with a start date of 5/1/19. Can someone help and...

I am trying to streamline employee course completion records for my company. I have 20 plus sheets and each sheet is named with an individual employees name. Each sheet is identical with column A holding course titles and column b that is blank for not completed or it is filled with a date if...

From the following example data set I would like to count the number of rows where "Company A" and the word "Completed" appear but not counting duplicate values in the first column and ignoring the blanks that might appear in the first column. It is ignoring the blanks I am having difficulties...

Hello, I am trying to figure out how to count unique values in column C (session) based on 3 conditions. <tbody> Name Course Session Status Date John Writing Skills Writing Skills - May 9 Completed 09/05/2018 Kelly Writing Skills Writing Skills - May 9 Completed 09/05/2018 Steve...

Hi guys, I was wondering if you could help - I have an observation form that has input boxes for Y/N in them that once completed I would love to be able to hit submit and the data is moved to a master file then clears the data from the form to use again for the next submission. Therefore over...

Hey all, I have a set of data I'm trying to calculate the cost / time per completed project. A completed project is one that has gone to "Prod". (production). I want to figure out a formula that takes the below data and calculates for me the COST (or time) spent on projects that are complete...

Hi All Im trying look at a start and end time and trying give 5 mins for every completed hour worked ie if someone worked 02:55 hours then that should return 10 mins as there are only 2 completed full hours but struggling with this formula Also trying to get a multiple or sumifs to total up...

Hello, I have a 2 page multipage userform. I would like one user to fill out the fields on the first page, email the workbook containing the completed userform to a second user that will complete page 2 of the userform (I would like all the fields filled out by person 1 to remain populated so...

- On Sheet 1 (FEED-2) I have the fiscal year (B5) with other information not applicable to this question it is just a what I call a feeder page. To get the fiscal year I have a table I created that is based off of the date to get the year, I tried just typing 2019 and still the same result...

This formula works, but if all cells are blank, it will show as completed because they are indeed equal to each other. How can I return a blank result, if all cells are blank? =IF((AND($T17=$U17,$V17=$W17,$X17=$Y17)),"Completed","Not Yet")

Hello, I'm looking to use a combination of index and match to do the following: Cell B1 contains a row number that is editable. I have it so once the row number is entered, cell B2 returns the first value completed in the given row. Now, I just need cell B10 to return the 'week' that the first...