Filtering Records Based on Specific Criteria

[LorenzTaylor]

Good Morning -

I am currently trying to filter records based on a specific criteria. 

In the attached data, if each group (Equipment Record) does not have 2 separate records which is "L" and "E" I want to remove those records and get the desired outcome.

I want to try to use the filter because I will need to bring this data back into my workflow down the line.

[aatalai · Accepted solution]

@LorenzTaylor take a look at this hope it helps

[LorenzTaylor]

This is perfect, Thanks! @aatalai 

[aatalai]

cool @LorenzTaylor can you mark the post as a solution?