Pick max date row

[priyankapassi]

Hi All,

My requirement is I need to pick only the rows with max-of-Date grouped by reqID.

Eg.

ReqID  Status  DateUpdated

1          open    5/10/2016

1          WIP      6/10/2016

2          open    5/10/2016

3          closed  8/10/2016

-------

In this scenario , for  ReqID=1, I need only one row i.e. highlighted in blue and followed by other.

Expected:

ReqID  Status  DateUpdated

1          WIP      6/10/2016

2          open     5/10/2016

3          closed   8/10/2016

-------

I cannot make any changes in Script.

Please suggest.

Thanks and Regards,

Priyanka

[Nicole-Smith]

You can use FirstSortedValue(Status, -DateUpdated) and FirstSortedValue(DateUpdated, -DateUpdated).  I've attached an example file.