Need Formula to pick the latest date from a range of cells

Hi,

I have a very big range of cells in a report. From that, I need to pick the status of a person i;e "Completed"and the report is having other status as well, like "Not Completed/ Dropped/ In Progress".

From all these status, only completed has to be pulled.

Here the challenge is, for a single person this data will have many Completion status in different rows, with their corresponding "Completion Dates".

Hence, I need to pull the Completion Status whose corresponding completion date should be a "Latest One".

Please someone help me with the formula.

I have attached a sample excel. In that i need the status of "C" with its corresponding Latest Date.

Thanks,
Fahim

I think you could benefit from ye' olde Pivot Table.

Or these:
Array formulas committed with Ctrl + Shift + Enter:

Formula:

Please Login or Register  to view this content.

Formula:

Please Login or Register  to view this content.

File attached.