Display most recent date allocated

[1429he]

Hi,

I have a sheet which shows the dates tasks were allocated to different staff members.

Can anyone help with a formula that would show the most recent date a task was allocated to each staff member (should also show where the task was allocated to more than one staff member).

Using the below table as an example:

Cell A2 would populate with the latest date Person A was allocated Task 1 (4/6/18)
Cell B2 would populate with the latest date Person B was allocated Task 1 (4/6/18)
Cell C2 would populate with the latest date Person C was allocated Task 1 (3/6/18)
Cells D2 & E2 would be blank, as Person D & Person E have never been allocated Task 1

Same principles for Task 2 - so cells A3:E3

New dates added daily, so to look for the furthest right value.

	A	B	C	D	E	F	G	H	I	J
1	Person A	Person B	Person C	Person D	Person E		1/6/18	2/6/18	3/6/18	4/6/18
2						Task 1	Person C	Person B	Person C	Person A/Person B
3						Task 2	Person D	Person D	Person A/Person B	Person B

<tbody>
</tbody>

Thanks