I am trying to build a critical path scheduling program and have 1 task per row starting in row 12 with 4 separate columns (H, I, J,K) where predecessor tasks are entered using the ID number of the predecessor (1-200) which are in A12:A211. There's nothing set in stone about 4 columns - it is usually more than enough for most schedules). I need to use this info to calculate the earliest start of each task based on the latest earliest finish of all of its predecessors. The earliest finish for each task us located in f12:f211
To do this, I have 4 columns AA through AD where I need to store the value of the cells in f12:f211 that correspond to the predecessor ID's - could anyone suggest which formula could be used to do this.
Thanks in advance!
To do this, I have 4 columns AA through AD where I need to store the value of the cells in f12:f211 that correspond to the predecessor ID's - could anyone suggest which formula could be used to do this.
Thanks in advance!