Have you tried

Data/Advanced Filter/Unique Records Only

?

In article .com,
wrote:

I have a large amount of redundant data that I need to filter. I have
a number in one column and in the next column a network location of a
file. I need to be able to extract the distinct records for this
data. Is there an easy way to accomplish this with a macro?