G
Graham
I have a project planner where the job # has a format x.001 thru x.999.,
where we can have multiple tasks for the same job.
I have a 2 sheets, 1 lists all the jobs that require work and 1 sheet lists
the available facilities and which jobs are currentlly active in them.
The facility sheet has colums job# (x.xxx) and a completion date and time
amongst other columns of info.
so I may have
lab# - job# - completion
1 - 1.001 - 17:01 Mar-23
2 - 2.001 - 03:42 April-5
3 - 1.008 - 01:00 Mar-22
the jobs will be inserted into the labs as they become available and the lab
sheet will not be in job order but lab order.
I want to be able to say job1 finishes at 01:00 on mar-22 ie the max of the
date column for the integer of the job column)
vlookup wont let me do that
any ideas?
where we can have multiple tasks for the same job.
I have a 2 sheets, 1 lists all the jobs that require work and 1 sheet lists
the available facilities and which jobs are currentlly active in them.
The facility sheet has colums job# (x.xxx) and a completion date and time
amongst other columns of info.
so I may have
lab# - job# - completion
1 - 1.001 - 17:01 Mar-23
2 - 2.001 - 03:42 April-5
3 - 1.008 - 01:00 Mar-22
the jobs will be inserted into the labs as they become available and the lab
sheet will not be in job order but lab order.
I want to be able to say job1 finishes at 01:00 on mar-22 ie the max of the
date column for the integer of the job column)
vlookup wont let me do that
any ideas?