Delete Rows based on if statement

[alannoble]

Hello, I have a rather complex spreadsheet with data like this.

A1 = Jams John
A2 = Alan John
A3 = James John

B1 = True
B2 = False
B3 = True

I want a formula that will check for false and delete the row if the cells in column A are duplicated

What would the macro look like

[jeffreybrown]

Do you know Excel 2007 has a remove duplicates function so no need for a macro.

Data >> Data Tools >> Remove Duplicates