You might be able to sort on columns D and F and block delete the rows you don't want, depends what order the data is in