LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Counting unique records yhtak Excel Worksheet Functions 6 June 16th 06 02:34 PM
In Excell-2000, database how do you extract unique records bgpereira Excel Worksheet Functions 5 December 24th 05 06:47 AM
i can not fliter unique records i can not fliter unique records Excel Worksheet Functions 0 August 25th 05 07:07 PM
Deleting specific records [email protected] Excel Discussion (Misc queries) 6 June 22nd 05 11:35 PM
In column A I have duplicate records. How do I tag an unique reco. Tian Excel Discussion (Misc queries) 2 January 13th 05 07:37 PM


All times are GMT +1. The time now is 07:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"