completed

I am trying to find or create a formula to compare to make sure that executed and completed, latitude and longitudes are a close match to the store longitude and latitudes closely match. I am thinking maybe a formula that will highlight the executed and completed coordinates green for close and...

Hi, I’m hoping that someone can help me out, as I’m somewhat stumped and realistically I’m still new to excel when it comes to anything more than your average spreadsheet. Basically I have a spreadsheet with 2 tabs, one with outstanding jobs listed on it, and another with completed jobs. I...

Hope someone can help. I've managed to get myself lost adding a number of days or COMPLETED formula. Essentially, I need to count the number of days since a task was completed so in J2 I've added =DATEDIF(I2,TODAY(),"d"). When the task is complete I need to add another date into K2 and for this...

Hello all! I am far from an excel expert so I really need your help if possible. For work, I am trying to create a spreadsheet that's simple for our mechs to use. I'm lost as to if or how I can get the hours/date next due to auto calculate based on the PM interval type they choose from the drop...

W2:Z2 could say required, not required, or completed If the cell says "required" it will eventually say "completed" once done. If it says "Not required", then it's not required. I want cell AA2 to say "Completed" once all cells say "completed" or "Not required" or any combination thereof...

I have a two part check list. Section and Area. I am using the formula =SUM(IF(FREQUENCY(MATCH(Table1[Section],Table1[Section],0),MATCH(Table1[Section],Table1[Section],0))>0,1)) to tell me how many different Sections there are. and =COUNTIFS(Table1[Area],"*") to tell me how many Areas there...

Hello, I am attempting to create a list of employees who finished reports on time. My issue is that my data sources have different interpretations of their name. I'll give an example. In Sheet 1: <tbody> Employee % Reports Completed on Time Hubert Humphrey Mary Shelley Fats Domino...

Hi Team, In advance thanks for your help. I have a group of four cells Y, Z, AA, and AB that can contain one of 3 values "Completed", "Waiting" or "Not App" If all four cells = "Completed" or all four cells = "Not App" then in Cell AE say "Validated" If any of the four cell contain any other...

Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> Data cells C6:C78, highlighted every 7th row with black background-white fonts, my query is I need to check cycle for 3 characters 1X2 when it is completed.</SPAN></SPAN> For the example...</SPAN></SPAN> C6=X, C13=1, C20=2, so far cycle of...

I have ordered date ..order co.pletion date and target date.. if an order is completed before target date it's not outstanding otherwise outstanding..I need to know how many orders where outstanding completed the next month and so on ...to get number of outstanding orders by end of each month in...

I am wanting to know if this is possible.. I have two months this month and last month which I have a work completed each month and i want to compare between the two. EG current month - June 18 - 76% last month - May 18 - 74% In another tab I have a dashboard screen with tiles in so I want...

Hello, I have the below code that is not doing what I need. It is clearing theadjacent data even if the date is less than the look-up date. I need the code to find all "Completed" statuses in column C, thencompare the date in column D. If the date is greater than the date in cellT1, then...

Out of all a two client has specific deadlines which is for client ABC= if any work recevied between Thursday to Wednesday it should be completed on every Wednesday For Client EFG= any work recevied between 21st - 20th of the month = the work sould be completed on 20 th of every month For...

Hello, Is there a way to create a vba code that will find text and clear contents in the preceding columns? For instance, I want to search for the word "Completed" in column D. Once it finds this word, I will need it to go to columns E, F and G and clear the contents on the same row it found...

I am trying to track when an outside contractor performs work on my job site using two metrics: date assigned and date completed. What I want is to find all occurrences of "OCD" in a worksheet, then have Excel look to the left and see if there is a date in the "Date Assigned" column and if...

Hi all If I’m trying to find out a percentage of a total where number of people to start were 0 - how do u show it for example An agent was assigned 2 tasks but he completed 4 would be 4/2 = 200% An Agent was assigned 2 tasks but he completed 1 would be 1/2 = 50% what if the agent was...

I want to automate something I do manually that takes a long time. I have a spreadsheet with training course data. I need to countif (I think) and show learner name (column B) who have "completed" (column F) a list of 13 courses (column G). I have the names of the 13 courses as they show in the...

I'm trying to count how many times a part of a word appears if a Yes condition appears in an adjacent column. The "2" is how many times "Yes" appears when the word "Task" appears also. Thanks for any help with this. Greg. <tbody> <tbody> Tasks Completed </tbody> <tbody> Description...

Hi All, Would really appreciate some help if anyone can provide. I'm not great with Excel but will try and explain as best as I can. My spreadsheet is used for tracking "Jobs in progress", so it's a live summary of all work going through. I have 3 sheets which are copies of each other, the...

Hello, I have a table which includes 21 columns, and roughly 275 rows. Column A list employee ID's, and columns B through V list on-line trainings that each employee must complete (1-20 training tests). The rows of data displays dates for each training that was completed. I would like to...