OS X 10.8 and later only. This script checks your entire iTunes library for missing and presumed dead tracks--those tracks that iTunes is unable to associate with a file and which are listed in iTunes with a "!"--and can create a text file listing these tracks by alleged File Path (if available), Song Name, Artist and Album, which you can view using TextEdit.
Also see Music Folder Files Not Added
To find and delete dead tracks see Super Remove Dead Tracks.
See the video on YouTube.
iTunes can't find the files pointed to by the Location property of these track entries.
Create text file listing tracks common to and exclusive to two playlists
Remove iTunes tracks disassociated from files
Make selected tracks NOT bookmarkable
Export artwork of selected tracks to parent or specified folder
Exports and then re-imports selected tracks' artwork
Create a Ringtone track from a selected track