I have a list of 8000 clients and about 1/3 of them have duplicate addresses, but with different names. Is there a way to use the delete duplicate feature to delete the repeated addresses in that addresses column and at the same time delete the whole row that the duplicated address is on?

Thanks

Jade