Unique Records Only is not working....

  • Thread starter Thread starter Bruce
  • Start date Start date
B

Bruce

I have a spreadsheet that I have many exported contacts for Outlook. I am
trying to clean up my Contacts. I have over 128K contacts in many folds,
most of these are dulicates. I figured that this would be fairly easy to do
in Excel.

When I try to filter and select Unique Records only, it does not filter
anything out. I even have some records I purposely copied and have included
blank records, but even these are showing.

I have sorted the records ( a conconation of all of the important fields,
removing spaces) as my "key" field

Any ideas?

TIA
Bruce
 
Are you just filtering on that column?

If you are, then do a small experiment. Compare two cells that show up as
different--but you think are different--with a formula like:

=a2=a3

Do you get True or False back?
 
You must log in or register to reply here.

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.

Ask a Question

Similar Threads

Exclude Unique Values 3
Filter unique on key fields only 8
Formula for unique records 2
How to delete all duplicate records - without keeping one of them 5
Filtering Duplicate Data to obtain Unique record 8
UNIQUE 1
Automatic filter for unique records 10
Finding Unique Records 1

Back
Top