I'm a bit confused you say
what I normally do is remove duplicates based on column Ethen sort based on column J and F then manually remove all non duplicates.

There must be a duplicate in both J and F, all other data can be deleted
Does this removal include non-duplicates in Column E?

Got to go for a while, I'll look back later tonight.