Delete rows based on unique combinations of 2 columns

Here's a simple way which uses a couple of helper columns.

In F2 (assume row1 contains column headers), put in this formula:

Please Login or Register  to view this content.

In G2 put in this formula:

Please Login or Register  to view this content.

Fill both the formulae down to the last row of data.

Since you want to delete any combination which appears only once, filter column G by TRUE and delete the visible rows.

1) Put a formula in an empty column that "tests" the A:B values. Something along the lines of:

M2: =($A2 & "-" & $B2 = "code1-code2")

That's a TRUE/FALSE construct. Edit the code1-code2 to the actual two strings you're trying to match.

2) Copy that formula down the data set to get all the TRUE/FALSE answers

3) Highlight the column and turn on the Data > Filter > Autofilter

4) Filter the column for FALSE

5) Highlight and delete all the remaining visible rows

6) Turn off the autofilter and clear the column you used

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.