iTunes - how do I delete duplicate songs that have exclamation marks?

I have thousands of these, it will take ages to delete one by one. I've tried sorting by various columns, but nothing will put all the exclamation mark songs together :(

Is there any way round this?
 
Back
Top Bottom