+ Reply to Thread
Results 1 to 2 of 2

similar part numbers

  1. 06-22-2011, 09:33 AM #1
    willn
    willn is offline
    Registered User
    Join Date
    06-22-2011
    Location
    Wisconsin,Wisconsin
    MS-Off Ver
    Excel 2003
    Posts
    1

    similar part numbers

    I am working on a project for work and i am trying to check for similar part numbers. These part numbers are from multiple companies and they don't nessasrly follow the same format. i have resurched into deleteing alpha characters and leaving myself with numbers but it doesnt seem to help.

    EX
    35-040-AL6061T6-0250X2000X2000
    AL6061T6-0250X3000X3000-35-040

    These are the same but I don't know how to get excel to reconize that. The format is not similar from part to part and not being extreamly familiar with excel functions I don't know what can be done.
    Reply With QuoteRegister To Reply
  2. 06-22-2011, 05:06 PM #2
    barryleajo
    barryleajo is offline
    Valued Forum Contributor
    Join Date
    06-19-2010
    Location
    Holywell, N Wales, UK
    MS-Off Ver
    Excel 2013
    Posts
    470

    Re: similar part numbers

    Hi Will
    Welcome to the forum.
    In the attached I have duplicated your examples in a small list for testing.
    Open the VBE editor and run the macro "dupartno()" from there.
    Then check the results in the Immediate Window at the bottom of the editor.
    This may take you forward some

    PS I don't think the partnos in your post are the same
    not unless X2000X2000 is the same a X3000X3000!!
    Attached Files Attached Files
    Last edited by barryleajo; 06-22-2011 at 05:09 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1