I have a large excel sheet that has 1500 rows. There are a few that have almost duplicate items in each cell in the row. I would like to be able to delete rows by comparing a column of cells and finding duplicates. So if I have something that looks like this:
1 blue
2 red
2 green
3 black
3 purple
I’d like to get rid of the first row by duplicate numbered cells so I’d end up with:
1 blue
2 green
3 purple
I’ve found help on getting rid of duplicate rows, but only if every cell in the row is the same. Is there an easy way to accomplish this without doing it by hand?