Has anybody know the macro for deleting entire row from worksheet if certain data in any cell of a row appears more than once. I want to keep only one row with the data and if it appears more than once the second row should get deleted.

For example.

say in row no. 5 in column A5 the data is "michael" in B5 the data is "John" and in row no.6 in column A6 the data is "michael" in B6 the data is "rosy".Here michael appears more than once, now i want to delete the entire row if michael appears more than once.