Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Chicago
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    linking worksheets/deleting records (xp)

    Hi All
    I have a list of records on one worksheet in a workbook - in column A are names, some of which are repeated. I have a similar list on another sheet in the same workbook. This one contains all the names from the first sheet - plus others. Again, there are repeats. I would like to delete from the second sheet every record that begins with a name that is not on the first sheet.
    Thanks much.

  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: linking worksheets/deleting records (xp)

    You can use MATCH to find repeats in sheet 1 from sheet2 something like this in B1 (or athere approprate cell)of sheet2:
    =iserror(match(a1,Sheet1!A1:A100,0))
    Then copy it down all the columns. (change sheet names and ranges as appropriate.

    If you have TRUE it is unique, false is not (a duplicate in sheet1)
    Add an auto filter to col b (data-filter-autofilter) and filter on col B for false select all the rows displayed and delete the duplicates

    Do the same for sheet1

    Steve

  3. #3
    2 Star Lounger
    Join Date
    Feb 2002
    Location
    Chicago
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: linking worksheets/deleting records (xp)

    Cool - thanks

Posting Permissions

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