how to keep a row based on a given condition and delete the other

[Mahesh6279]

I have an excel where i have part and plant combination. 

I would like to keep the row based on a condition else delete the row.

the condition is as follows 

1. If the column " Category" = SA I would like to keep the row else delete

2. if the Part and Plant combo does not have SA but only SB the keep the row

First preference is categort 'SA' to keep the row

[dkungu]

Hi @Mahesh6279 

You can achieve this using below 

[griffinwelsh]

@Mahesh6279 Here is a simple solution.  Note this will eliminate duplicate rows as well.

1. Sort by category in ascending order

2. Summarize tool: group by Part and group by Plant. First Category