Why can't I sort songs with !'s next to titles (meaning these songs don't exist in Library but actually do)? I really don't want to scroll through 5,000 titles to remove these items.
When tracks in iTunes display a it means the file cannot be located; it may have been moved or deleted. For this issue, we will need to refer to the following article:
iTunes: Finding lost media and downloads
Alternatively, if your media was downloaded from the iTunes Store, you may be able to download it again free of charge:
Downloading past purchases from the App Store, iBookstore, and iTunes Store
Retrieving data ...