Extracting distinct data

[asa.flynt.reynolds]

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?

 

[JE McGimpsey]

Have you tried

Data/Advanced Filter/Unique Records Only

?