Hello Excel Guru's,
I need your help on how to do this in Excel 2013.
I have 2 tabs, 1 for details (source data) and 1 for my summary (target).
In the summary tab, I need to mark the Name of the animal with X if in the Remarks column the cell value is blank based on the latest End date.
Hope you can help me out. Thanks in advance.
https://drive.google.com/drive/folders/1F6ctu1MZP_QCfCnTTSySRR7buSsbXyx6?usp=sharing
Summary tab
Details tab
I need your help on how to do this in Excel 2013.
I have 2 tabs, 1 for details (source data) and 1 for my summary (target).
In the summary tab, I need to mark the Name of the animal with X if in the Remarks column the cell value is blank based on the latest End date.
Hope you can help me out. Thanks in advance.
https://drive.google.com/drive/folders/1F6ctu1MZP_QCfCnTTSySRR7buSsbXyx6?usp=sharing
Summary tab

Details tab
