I have a complicated, for me, question. I have a 2 sheet(job list and long term schedule) excel file that i use to track and schedule 16 crews on jobs. One sheet is a job list, that contains a job number for each job and a column that i put the first date it shows up on schedule. The second sheet is a year long schedule that I use to schedule my crews. Along the top row is the date and then 16 crews are listed down the left side. I then Put job number and location each day for each crew. What i want to do if create a formula on my job list that will search the long term schedule sheet for the 1st time a job number shows up and then reference that date.
Does that make sense? Ive tried many formulas, then came upon this site hoping to find some help.
Does that make sense? Ive tried many formulas, then came upon this site hoping to find some help.