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
Bookmarks