Hello.
I am trying to develop a spreadsheet which tells me the last time a certain individual worked a particular task within my team.
The data I have to work with is, for example, as follows;
Column A: Staff Name (Joe, Steph, John (Up to 80 names)
Column B: Task Name (Task A, Task B, Task C(Up to 20 tasks)
Column C: Date task carried out (DD/MM/YYYY)
Currently, I have managed to use the below formula to determine the last time a particular task was done, but I can't seem to figure out how to include a name search to make the results more specific.
=MAX(IF($C$2:$C$483="Task A",B2:B483))
Does anyone know how I can search for particular names in Column A, so that it can tell me the last day John worked Task A?
Hope this makes sense.
Jamie.
Bookmarks