Using Excel 2007
Column D (D3:D2000) contains dates, to which those dates are repeated....for instance I can have ten cells in column D with todays date, 2-25-13.
Column L (L3:L2000) Will have the name of a project and much like the dates the project can be repeated multiple times....so I can have a project called P0ABC123 listed twenty times in colum L and it be associated with various dates in column D...for example I can have P0ABC123 listed 3 times and the date could be 1-30-13....then I can have it listed five more times and the dates for those five times in column D can be 2-12-13.
I would like to have a formula that says does this:
"Look in column D for date range 2-18-13 thru 2-24-13 and then look in column L and list each project worked in that range.......then in another cell give me a count of how many jobs we worked in that range."
So if I have ten P0ABC123 in the date range, only list it once.......and if that was the ONLY job I worked in that range then the other cell that does the counting will have the number 1.
This is waaayyy too complicated for me to figure out I dont even know where to begin to start writing the formula.
Column D (D3:D2000) contains dates, to which those dates are repeated....for instance I can have ten cells in column D with todays date, 2-25-13.
Column L (L3:L2000) Will have the name of a project and much like the dates the project can be repeated multiple times....so I can have a project called P0ABC123 listed twenty times in colum L and it be associated with various dates in column D...for example I can have P0ABC123 listed 3 times and the date could be 1-30-13....then I can have it listed five more times and the dates for those five times in column D can be 2-12-13.
I would like to have a formula that says does this:
"Look in column D for date range 2-18-13 thru 2-24-13 and then look in column L and list each project worked in that range.......then in another cell give me a count of how many jobs we worked in that range."
So if I have ten P0ABC123 in the date range, only list it once.......and if that was the ONLY job I worked in that range then the other cell that does the counting will have the number 1.
This is waaayyy too complicated for me to figure out I dont even know where to begin to start writing the formula.