Close

Results 1 to 3 of 3
  1. #1
    DF VIP Member daz73's Avatar
    Join Date
    Jan 2003
    Location
    Cardiff
    Posts
    4,561
    Thanks
    5
    Thanked:        1
    Karma Level
    493

    Default Data matching in excel..

    Hi guys, need some help here..

    Got a sheet with names and number on it.. Need to remove names & Numbers in column A & B which are in column E & F (see attached) as they are duplicates....

  2. #2
    DF VIP Member flumperino's Avatar
    Join Date
    Jan 2004
    Location
    Isle of flumps
    Posts
    9,612
    Thanks
    521
    Thanked:        679
    Karma Level
    881

    Default Re: Data matching in excel..

    Probably a simpler way, but this is how i'd do it.

    In a blank cell, say H1, type =VLOOKUP(A1,$E$1:$E$60,1,FALSE)
    Copy this down the column to the bottom line of data.

    Those which are doubled up in column A and E will give the name. Those which are not will give #N/A.

    Filter the whole lot, and do a cutom filter of 'does not equal #N/A'

    Then delete all the records in colmn A that you don't want (delete the text or the cells, not the entire rows).

    Same sort of thing should apply if there are other columns with data

    Shooooooo-ryuken!

  3. #3
    DF VIP Member daz73's Avatar
    Join Date
    Jan 2003
    Location
    Cardiff
    Posts
    4,561
    Thanks
    5
    Thanked:        1
    Karma Level
    493

    Default Re: Data matching in excel..

    cheers flump....

Similar Threads

  1. windows 2000 corrupting data
    By samueljames in forum PC Problems
    Replies: 3
    Last Post: 9th October 2002, 05:59 PM
  2. Excel graph problem
    By marktb in forum PC Problems
    Replies: 2
    Last Post: 9th October 2002, 04:42 PM
  3. 3310 data cable question
    By lanko in forum Unlocking Questions & Solutions
    Replies: 2
    Last Post: 25th September 2002, 07:00 PM
  4. A110e Data Cables
    By fonetech in forum Unlocking Questions & Solutions
    Replies: 3
    Last Post: 9th September 2002, 11:34 PM
  5. T100 data cable
    By fonetech in forum Unlocking Questions & Solutions
    Replies: 5
    Last Post: 31st August 2002, 08:26 PM

Social Networking 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
  •