dependencies

  1. VBE313

    Improve Calculation Speed

    Is it faster to have fewer dependencies and more columns or vice versa? Thanks
  2. P

    Flowchart based on table of dependencies

    I need to automatically create a flowchart based on a table containing dependencies and items. It would be formatted like this (two columns): Item - Dependencies Item1 - Item3,Item4,Item5 Each item can have multiple items on which it depends and some items will be dependencies of multiple...
  3. H

    Inserting a shape based on multiple excel values?

    I am creating a Gantt chart and one of the last steps is getting a view of milestones on my Gantt. For this I would like to insert a shape whenever column C has a value, "Yes" and then place the shape on the row based on the date entered in column E. Here is what my sheet looks like so far...
  4. A

    Track task dependencies in Excel

    I have two tabs in my excel sheet. Tab 1: Contains a list of all the dependencies across multiple functional area. The columns are functional area, dependency description, dependency id, plan end date, target end date. Tab 2: Contains a list of tasks with the following columns: Functional...
  5. A

    Logic Formulas for Dependency Tables

    Hey folks, Take a look at these three dependency tables: Let's take Dog as an example. In order to produce a Dog, you need to consume a Car and a House (1st degree dependency, first table). However, in order to produce a Car, you need to consume a Computer, and in order to produce a House...
  6. N

    Lookup Multiple Entries AND Expand Lookup to Include Dependencies

    Hi All, I have a list of hundreds of server with multiple applications on them. I want to lookup and list all servers with the same application on them but also want to identify server dependencies which occur through additional applications on the server. Hopefully this example will explain...
  7. N

    Setting Start dates based on dependencies

    Hi, I have this spreadsheet which has tasks with one or more dependencies. These tasks can begin only after their dependencies are complete i.e. start date of task > max of end dates of its dependencies. I need to validate the start date of all the tasks which have dependencies based on above...
  8. J

    Excel Multiple Index+Match Returns with double dependency

    Hello All, I've tried searching for my following query but had no luck so starting a new topic. I have the following table <tbody> Col-A Col-B Col-C A-1 B-1 C-1 A-2 B-2 C-2 A-2 B-2 C-3 A-2 B-3 C-4 A-3 B-4 C-5 A-3 B-5 C-6 A-4 B-5 C-7 A-4 B-6 C-8 A-5 B-7 C-9 A-5 B-8 C-10...
  9. A

    Difficulty with cascade boxes

    I'm an Access newbie (first time user) and am struggling with cascade boxes. I haven't been able to find anything that has helped me. I am trying to create boxes with dependencies. I have Stage. Then Step which is dependent on stage. Then Task which is dependent on stage. The primary key for...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top