Deleting duplicating rows

[sampahmel]

Hi,

Say I have 2 columns: Insurance Policy Holder ID & Claim No.

If the Insurance Policy Holder ID & Claim No. both repeat in 2 rows, I would like to delete one of them.

If the Insurance Policy Holder ID repeats in 2 rows but the Claim No. in each row is unique, I would like to keep both.

Is there anyway to do both in the same spreadsheet?