Is there any way on iTunes to delete all the songs with a ! mark?

[jesus c]

how do you delete all songs with a ! mark next to them and how can u get iTunes to remove all duplicated sons from same album automatically?

Thanks!