Filter for max date

[ABHalpain]

I am trying to solve for the following variations in my data set.  I need to filter rows to only keep the most recent effective date.

data sample and desired results are attached.

Any Ideas would be greatly appreciated.

[BRRLL99 · Accepted solution]

use summarize tool and group by column and Max date

no need to use select and filter tool

since your sample data has nulls and unwanted columns so i used select and filter tools

[Dina · Accepted solution]

Use the Summarize tool to figure out the Max Effective Date by EE, then use join to pull out the related records.

[RSreeSurya · Accepted solution]

Hi,

Attaching the sample workflow, using sort and summarize tool. 

[ABHalpain]

Thank you all!!!