Comparing 2 columns and deleting uncommon elements

ENTHU

I have a table in which I am trying to calculate the number of hours spent for all application to complete processing. To do so I need to consider only the applications that have both stages.So I need to get a list of all applications at processing and all applications at pre-processing.Compare the 2 lists and delete applications that only have pre-processing.How do I achieve this?

 

Stage.xlsx

txnelson

Split the data table Split By the Stage column, Group by the Application No. and use Hours Spent as the Split Column.  Then simply click on one of the cells that has a missing value for the Process column, and choose, Select Matching Cells.  Then go to the row state column, right mouse click on one of the selected rows, and choose, Delete Rows.