Hi all

I am struggling to find the correct formula for the following problem:

I need to identify if the row got the latest report date for the project mentioned in column A. If this is the case the specific cell in column C should mention this (e.g. “Project A Latest”). Otherwise the cell should be left blank.

Column A
Projects
Project B
Project B
Project B
Project A
Project A
Project C
Project C

Column B
Report date
15-Sep-16
31-Aug-16
1-Apr-16
1-Jul-15
15-Sep-16
12-Nov-16
1-Nov-15

Column C
Identifier


Many thanks!