This is a very difficult thing to do in Excel. I think you have to write
some VBA to do it. Maybe you can export it to an access database for
example, and then retrieve the values with a group-by query. This way
the database engine solves your problem.
Select the range, use Data/Filter/Advanced filter
check Unique Records Only and "Copy to another location"
Put in an address to hold the result, eg[F1] then click
OK. When you're done, you will have the unique records in
the new place.
You can delete the original range or not.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
