Filter for max date

Question

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.

Sample.xlsx

BRRLL99 · Accepted Answer

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 Answer

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

RSreeSurya · Accepted Answer

Hi,

Attaching the sample workflow, using sort and summarize tool.