task

Maybe my sheet is inefficient but what i am trying to do is have a task list scheduling tool. Basically I have a list of 30K tasks that can be assigned to various team members. Each task has a certain amount of time allowed and a start and end date. If a task takes 5 hours and we have the...

Hi I'm trying to have an index match or equivalent whereby in cell B5 in looks for a daily task then if there is one displays "Daily Task" In cell B6 it then needs to look for a Post Task or a Month task likewise in B7 I have the index match for looking to see if theres a task for each...

Good morning all, i have scoured through MR Excel, and many others but have not had any luck. This maybe due to not using the right keywords in google. Alas, i have had to create this post for help. The best way to describe this issue is something that is done automatically within MS Project...

Hello. I'm not 100% sure if what I'm trying to achieve is possible in the way that I'm trying to do it, but any guidance on how to start would be much appreciated. Basically my goal is to create a workflow chart to standardize the tasks for specific processes. I have the column "Tasks" B:B...

Hi everybody, I have a question regarding a task which I do at work and which involves excel. Since the real sheets contain sensitive information I've made two very simple example sheets which i attached below, blue is sheet1 & yellow is sheet2. I hope this is enough to understand what I...

I have to create a work plan spreadsheet that tracks tasks, which have steps. <tbody> Task X Status Step 1 1. Status 1 Step 2 2. Status 2 Step 3 3. Status 3 Step 4 4. Status 4 Step 5 5. Status 5 Step 6 6. Status 6 </tbody> As each staff member completes the step, they will...

I have a range where I need to derive the level/depth in the hierarchy for each cell where some cells are comma seperated , for example: <tbody> Task SubTask ParentTask T1 T2 T0 T5 T3,T4 T8 T2 </tbody> In this example range, the level of T0, T5 is 1. The level of T1,T3,T4 is 2. The...

First I am sorry if this has been asked previously but I could not find anything that helped me out. I have a spreadsheet that is about 500 rows and part of it includes 8 columns representing the last 8 years. In some of the columns there are dates and others are blank. I want to compare all 8...

Hello. Is there any way to exclude the cell from the range? Here is the deal, this is how my sheet looks now (grey cells doesn't contain a formula) I2:I11 - people that need to be connected to the task (there are 6 tasks - M3:M8 ; H15:H20) J2 - there is RAND() formula N3:N8 there is...

Hi, I have three columns. Column A has the task type , column B the number of days and column C has the status as Completed or Pending. I need to show the maximum days pending for any task that has been tagged as Pending in column C. I am using the following formula but it does not work...

I have two table one is my project table and it contains all information regarding any projects that we have. I also have a Timesheet table that gives me all employees timesheet data. Both tables contain 3 identical column Project Number, Project Task Number, Project Subtask number. I want to...

Hello, I need help please. Say I have 3 identically formatted data workbooks with different data in each, but all located in the same folder. Data Workbook1: <tbody> Name: Company A Location: Texas Task 1: Yes Task 2: Yes Task 3: No Task 4: No </tbody> Data Workbook2: <tbody>...

Hi, Can someone please help me with this? I have 5 column of raw data like this: Employee, Month, Day, Type of task, Hours Without using pivot tables, I would like to summarize the information in a table like this: <tbody> Dec-18 Jan-19 Feb-19 Total quater Days Days Days...

I created a form of task and the completed task will be identified by a checkbox as clicked. The field is Task Completed: "checkbox". If the box is checked, then it is completed. The checkbox has to be done by a manager so I need to have to build a pop-up form (frm_Pin) with VBA code attached to...

https://photos.app.goo.gl/JiRjueNTERUmu2ev6 I'm trying to auto populate the area in yellow in the screen shot (see link) with the tasks. Each week a person does a task, the next week they move on to a different task. They never repeat the same task in a 4 week period. Its always a 4 week...

Hi, I have 2 tabs the 1st has a list with 200+ task ID's which is listed in Column E and then another tab with all of the data. The 2nd tab with the data on has the date running down column A and then the Task Id in Row 1. I have been using the following formula to retrieve the data from an date...

Hello, I am trying to distribute predefined task hours evenly on working days (NETWORKDAYS) between 2 dates. I don't need to see the number of hours listed on each day, however, I do need to see the number of hours by month. Below is an example. I am looking for a formula to calculate the...

Hello everyone! I've recently got a task to do in excel: "There are points A(-1,0) and B(3,0). Find point C, for which the ACB angle is a right angle." There was also something mentioned about the method of searching an axis??? I understand this and I know how do do it on paper but have...

Hello I recently have started a new job that requires me to use a lot of excel for my day-to-day.. I've learned so much, and I'm starting to watch videos and learn even more than I could imagine. I'm stuck though on an issue I would like to be able to automate. I have this daily report.. It has...

Preface: MicrosoftProject is not an option, and I am trying to avoid having to manually changecolumn names in the data output file. Thecolumns are not always in the same position in the data dump. Vlookup and Offset using the task numberdoesn’t work because the total number of activities on...