Skip to Content

Help with variable to return the latest date against the same category

Does anyone have any suggestion on the variable formula to do this:

Currently data organized as:

vessel name ETA to port

ANNA MAERSK 3/16/2021

ANNA MAERSK 3/20/2021

ANNA MAERSK 3/21/2021

I need variable to take the latest date 3/21/2021 and replace all other values (3/16 and 3/20) with this latest date.

Thank you so much in advance!

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Feb 23 at 10:16 AM

    latest date: =Max([Date]) In ([vessel name])


    hope that helps

    maxd.jpg (31.0 kB)
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.