The duplicates

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: The duplicates

  1. #1
    Board Regular
    Join Date
    Sep 2002
    Location
    Iran
    Posts
    91
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have a series of info in my cells which some of them are repeated. I need a macro to check for the duplicates and finds them. Also I want the code to check the contents of the cells and if a new entry is inserted alerts for it. Could any one help me?

    Regards


    Eqbal Vakilzadeh Ebrahimi

  2. #2
    Board Regular
    Join Date
    Jun 2002
    Location
    Bridgeport, Ct
    Posts
    340
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I do not know if you would be interested but here is a non VBA approach. The first formula looks up last & first name the second looks up only the first name


    ******** ******************** ************************************************************************>
    Microsoft Excel - Book1___Running: xl2002 XP : OS = Windows XP
    (F)ile (E)dit (V)iew (I)nsert (O)ptions (T)ools (D)ata (W)indow (H)elp (A)bout
    =

    A
    B
    C
    D
    E
    F
    1
    Last NameFirst NameSchool IDSS2 Variables1 Variable
    2
    JensenBill12046-62-8917

    3
    O'BrienLinda12074-56-8604

    4
    GalburtAmy12043-64-4909

    5
    SoarsJoan21041-59-8999

    6
    SavranLinda9023-46-5837

    7
    CrevierCheryl4585-13-9868

    8
    SoarsJoan3576-98-1231DuplicateDuplicate
    Sheet1

    [HtmlMaker 2.20] To see the formula in the cells just click on the cells hyperlink or click the Name box
    PLEASE DO NOT QUOTE THIS TABLE IMAGE ON SAME PAGE! OTHEWISE, ERROR OF JavaScript OCCUR.

  3. #3
    Board Regular
    Join Date
    Jun 2002
    Location
    Bridgeport, Ct
    Posts
    340
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Edit: The second formula only looks up the last name.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com