I am attempting to create an Excel file that will allow my supervisors to view the last date an employee entered activities into their excel file.
A workbook is set up for each employee with column K holding employee numbers and column a holding the dates. There is a different sheet for each month and a book for each employee. Part of the problem is that a co worker could be listed as a partner on project, requiring each row to be searched.
My intentions were to develop a nested 'max-if' formula, however, the formula below, which only searches on book, would not work.
=MAX(IF(D4=Jan:Dec!K4:K660,Jan:Dec!A4:A660))
Any help would be greatly appreciated. I have already spent far too much time on this project.
A workbook is set up for each employee with column K holding employee numbers and column a holding the dates. There is a different sheet for each month and a book for each employee. Part of the problem is that a co worker could be listed as a partner on project, requiring each row to be searched.
My intentions were to develop a nested 'max-if' formula, however, the formula below, which only searches on book, would not work.
=MAX(IF(D4=Jan:Dec!K4:K660,Jan:Dec!A4:A660))
Any help would be greatly appreciated. I have already spent far too much time on this project.