View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bruce Bruce is offline
external usenet poster
 
Posts: 18
Default Unique Records Only is not working....

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