Assigning a Status when ID is duplicated and multiple condition in another column

[tf05]

When a duplicate ID is found I am looking to add a new column to indicate if the status is the latest one or not. I need to keep all the data in the workflow as I will be reporting on the other statuses later on.

Input and desired output attached.

Any suggestion much appreciated.

Thanks

[tf05]

When a duplicate ID is found I am looking to add a new column to indicate if the status is the latest one or not. I need to keep all the data in the workflow as I will be reporting on the other statuses later on.

Input and desired output attached.

Any suggestion much appreciated.

Thanks

[DataNath · Accepted solution]

Hey @tf05 - I believe this should do the trick! Let me know how you get on.

[binu_acs · Accepted solution]

@tf05 one way of doing this