Macro to delete duplicate rows based on empty cells

Hi all, I was wondering if someone can help me with my excel problem using a macro.


A | B | C
INV # TRANS # LEDGER #
---------- ---------- -------------
1 12345 T12345 LED123
2 12345 T12345
3 67890 T67890 LED123
4 67890 T67890
5 88888 T88888

Based on above example, I would like to be able to delete row 2 and row 4 because row 2 and 4 are duplication of row 1 and 3 respectively. Notice that C2 and C4 is empty. I do not want to delete row 5 because there isn’t a duplication and column C5 is empty. So once I run the macro it would look like this:


A | B | C
INV # TRANS # LEDGER #
---------- ---------- -------------
1 12345 T12345 LED123
2 67890 T67890 LED123 <-- this used to be row 3 from above example
3 88888 T88888 <-- this used to be row 5 from above example


Right now I am deleting these about 1500 rows manually and it’s very time consuming. Hopefully this makes sense to you and you are able to help.

Thanks.

sorry this made a wrong assumption
ok try number 2
column labels in a1 b1
in d2 put
=SUMPRODUCT(--($A$2:A2=A2),--($B$2:B2=B2))>1
data/filter advanced filter
list range a1:b5000
criteria range
$D$1:$D$2
filter in place
delete visible rows