Hi Everyone,
I have an issue at work.
I desire to obtain the output similar to what I entered manually in the MAX column (Colored Green) using a formula.
Formula should
1. Look for a Name (Column A) and Week Start Date (Column J).
2. It should then mark "Latest", when the value in Entry Time (Column I) is the most recent one for a given Name and Week Start Date.
3. Mark "Not Latest", when the value in the Entry Time is not the most recent one.
Please help me! I am struggling with this one.
Thanks a lot.
Bookmarks