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.
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?