So I have column A and column C. Both columns have duplicates. However I only want to delete based on the fact that there are duplicates if combined column A and column C have the same values.
Example:
Column A Column B Column C
Cool-1 Def Story
Cool-1 Def Story
Cool-1 Def Movie
Cool-1 Def Book
Cool-1 Def Story is essentially is the duplicate. How would I remove just those type of duplicates?