Is there a way to remove duplicate row values dependent upon the value in another cell?
I have attached an example. I wish to remove all rows apart from the first row that shows an entry in both columns A & B.
As you can see, sometimes there are three duplicates (A2-A4) and sometimes two (A5-A6)
Bookmarks