Dear Team Kindly refer attached file. I have Site Id & Town Name in Column A & B in that I have delete Site Id Expcept 1st One, same as I mentioned in Column D. Thanks in advance Regards Basavaraj K H