+ Reply to Thread
Results 1 to 3 of 3

How to check for dupes on 2 files, and ? about csv file ext

  1. #1
    PeterM
    Guest

    How to check for dupes on 2 files, and ? about csv file ext

    I have two files, one has a csv ext and the other one a Excel 2003
    extension. both open up in my 2003 Excel. How can I strip the duplicates out
    of the file. One is 4400 names and one about 1100. I tried to do it on the
    csv file, and then when I tried to save the file I got all kinds of replies
    that made me nervous and I cancelled the operation. What is that csv file,
    (I know the name comma separated value????) someone said it is the same as
    the excel file, they just changed the extension. Is that true? Supposedly
    the people that will write invitation cards from this list wanted it in that
    csv format. Is that so different from the regular excel file? Both files
    look exactly alike, just first name, last name, address city and zip code.
    Maybe I need a lesson on this. I appreciate any help with my
    questions.......Peter


  2. #2
    Forum Expert
    Join Date
    12-24-2004
    Location
    Sweden
    Posts
    1,256
    Put them both in one file, then use the Advanced filter...
    Menu: Data>Filter>Advance filter... and tick Unique Records Only

    Ola Sandström


    And...if you would like to separate your data into separate Columns, use:
    Menu:Data>Text to Columns> ...
    Last edited by olasa; 06-04-2005 at 06:05 PM.

  3. #3
    Dave Peterson
    Guest

    Re: How to check for dupes on 2 files, and ? about csv file ext

    First, CSV files are just plain old text files.

    If you open Notepad and then File|Open your csv file, you'll be able to read it
    without too much trouble.

    But if you open a real excel file (not just a renamed csv file to xls), then
    when you open that in Notepad, it'll look mostly Greek.

    (If you try this, be very careful. If you change something (and save it) in
    that .xls file in Notepad, you could damage it so that excel can't open it.
    (Test it on a copy if you really want.))

    Excel is pretty forgiving with .csv files renamed to .xls. (But on general
    principles, I don't like doing this type of thing.)

    And if you really want to work with duplicates, Chip Pearson has lots of ways
    at:
    http://www.cpearson.com/excel/duplicat.htm

    PeterM wrote:
    >
    > I have two files, one has a csv ext and the other one a Excel 2003
    > extension. both open up in my 2003 Excel. How can I strip the duplicates out
    > of the file. One is 4400 names and one about 1100. I tried to do it on the
    > csv file, and then when I tried to save the file I got all kinds of replies
    > that made me nervous and I cancelled the operation. What is that csv file,
    > (I know the name comma separated value????) someone said it is the same as
    > the excel file, they just changed the extension. Is that true? Supposedly
    > the people that will write invitation cards from this list wanted it in that
    > csv format. Is that so different from the regular excel file? Both files
    > look exactly alike, just first name, last name, address city and zip code.
    > Maybe I need a lesson on this. I appreciate any help with my
    > questions.......Peter


    --

    Dave Peterson

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1