Just an alternative,

Can anyone know how to use AdvancedFilter dunction to delete identical row?

I tried AdvancedFilter. But it only hide the identical row, which I do not need.

Please advise.

Thanks.