Hi all,
Can anyone help me with a formula for this please????
I think the best way to explain is with a sample file. But what I am trying to do is: delete rows where there is a duplicate value in Column B, but only a duplicate when column A is the same value. In the sample file, I highlighted the cells that I want to delete in red. The Results worksheet is what finished product should look like. The real file has 40 columns and 7000 rows.
Bookmarks