Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Location
    Houston, Texas, USA
    Posts
    100
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Find/Remove Duplicate Entries (2000)

    Please see the attached file. We would like a macro which would allow us to be able to identify and remove any duplicate records (based on names in column A, "Nodes") It would, preferably, remove those duplicates that appear in lower case, as opposed to the upper case norm.

    We have already used a COUNTIF formula and copied that down throughout the list in a second column (see file). We then use AutoFilter to identify the dupes, but this is cumbersome. We would like a more automated way to eliminate the duplicates.

    I appreciate any help that anyone can offer!

    S. Thomas

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Find/Remove Duplicate Entries (2000)

    You don't need a macro:

    You can use data - filter - advanced filter to filter for unique records and then copy them elsewhere (however all your records are unique)

    If you just want to remove duplicate names, you can parse your data first (select the column, data text to columns, delimited, <next>, check comma<finish>

    Now you can insert a new column A (select B1, insert column) and enter the formula in A2:
    =COUNTIF($B$1:B2,B2)>1
    and autofill down the rows.
    Now select column A and edit copy - edit paste special values to convert to numbers.
    Data - filter - autofilter
    select the pulldown in A and choose true, highlight these cells and delete.

    You have removed the dupe names (and kept only the first one).

    Note, your example has no duplicate nodenames

    You can automate it, by recording the macro if desired, but I leave that as an exercise.


    Steve

Posting Permissions

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