Hi I want to highlight duplicate rows. I would define a duplicate as, if column A & column M repeat anywhere, I have tried filtering and conditional formatting but just cant get it to work
So in the example attached you could highlight the rows where A & M match with other rows, I have highlighted the two columns to compare
Many thanks
Bookmarks