Keeping the latest instance of a value based on criteria

[gvillanueva1009]

Hello - I have the following scenario where I want to keep all the approved requisitions and only keep the latest final disposition date for the Closed requisitions. Can you please assist? Thank you!

Unique ID            Req ID        Title                      Status         Final Disposition Date     As of Date

ABC12312019      ABC123      Goal Digger         Approved                                           1/31/2019

ABC12322019     ABC123       Goal Digger         Approved                                           2/28/2019

ABC12332019     ABC123       Goal Digger         Closed                    3/25/2019            3/31/2019

ABC12342019     ABC123       Goal Digger         Approved                                            4/30/2019

ABC12352019     ABC123       Goal Digger         Approved                                            5/31/2019

ABC12362019     ABC123       Goal Digger         Approved                                            6/30/2019

ABC12372019     ABC123       Goal Digger         Closed                     7/2/2019             7/31/2019