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?
Bookmarks