you could use =countif(F:F,F1) copied down

Then apply filters and filter on that column for anything greater than 1...delete all those rows, remove filter