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.

[TABLE="class: grid, width: 500, align: center"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Person A[/TD]
[TD]Person B[/TD]
[TD]Person C[/TD]
[TD]Person D[/TD]
[TD]Person E[/TD]
[TD][/TD]
[TD]1/6/18[/TD]
[TD]2/6/18[/TD]
[TD]3/6/18[/TD]
[TD]4/6/18[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Task 1[/TD]
[TD]Person C[/TD]
[TD]Person B[/TD]
[TD]Person C[/TD]
[TD]Person A/Person B[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Task 2[/TD]
[TD]Person D[/TD]
[TD]Person D[/TD]
[TD]Person A/Person B[/TD]
[TD]Person B[/TD]
[/TR]
</tbody>[/TABLE]



Thanks