Guys ..

Currently, I've been maintaining my MP3's on Windows and Sync'ing (FTP) the files over to the Mac (iTunes Music folder) where I then have iTunes rescan my music folder (File:Add to Library) then I sync up with the iPod. My issue is When I sync the Win MP3's over to the Mac (Adding new files, Updating changed files and deleting removed files) The deleted files show up in iTunes with an '!' in the 1st column (Can't locate the file). I can't see a way to group these files together so they can be removed from the library easily or to remove them automatically .. I have to scroll through the entire library (6000+ files) looking for the '!'. The problem is that the song won't be deleted from the iPod until it's deleted from the library.

Is there any way around this?