I need to delete or hide ALL rows that have duplicates in 1 Column (read for full details)
TL;DR; I need to delete or hide ALL rows that have duplicates in Column B (Title).
DETAILS:
I have an excel file of my personal physical media collection. (I also use free Windows app called EMDB but that doesn't have the filter option I need either.)
I want to view all Titles that I have that are ONLY on DVD. If I remove duplicates it only removes 1 row instead of both. Which I know is the intended function.
Example highlighted in the photo. Both those rows should be deleted or hidden because that title is not DVD-only in my collection. NOTE: Those 2 are highlighted because I manually highlighted them for the screenshot to point out my example. So there is no highlighting in the original content.
[link] [comments]
Want to read more?
Check out the full article on the original site