+ Reply to Thread
Results 1 to 7 of 7

how to identify only 3 digit permuted number from list of 4 digit number

  1. #1
    bigcrap
    Guest

    how to identify only 3 digit permuted number from list of 4 digit number

    Hi if anyone could help me with ways to how to identify only 3 digit permuted number from list of 4 digit number using excel .

    Example

    If i want to make sure let say we a list of 4 digit number 4568,5678 and 2345 and i want to identify let say 865,765,342(permuted number) is a part of the 4 digit number,how to go about it.Thank You

    PS:Sorry for my username.I don't know how to edit it
    Last edited by bigcrap; 05-10-2011 at 11:15 PM.

  2. #2
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: how to identify only 3 digit permuted number from list of 4 digit number

    bigcrap,

    Welcome to the Excel Forum.

    To get the most precise answer, it is best to upload/attach a sample workbook (sensitive data scrubbed/removed) that contains an example of your raw data on one worksheet, and on another worksheet your desired results.

    The structure and data types of the sample workbook must exactly duplicate the real workbook. Include a clear and explicit explanation of your requirements.

    To attach your workbook, click on the New Post button, then scroll down and click on the Go Advanced button, then scroll down and click on the Manage Attachments button.
    Have a great day,
    Stan

    Windows 10, Excel 2007, on a PC.

    If you are satisfied with the solution(s) provided, please mark your thread as Solved by clicking EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

  3. #3
    bigcrap
    Guest

    Re: how to identify only 3 digit permuted number from list of 4 digit number

    Thank you Stan for your reply.Sorry i don't have a sample worksheet.

    Let say we have this set of number (3 Digit) number 235,123,541,544 and (4 digit) number 1235,2523,1425,4458.

    I need a formula to identify or track if the 3 digit numbers(each one of that 3 digit) is in the 4 digit number.

    For example
    235 is in 2135 and 2523 (note that digit 2,digit 3 and digit 5 can be in anywhere in that specific 4 digit number)

    Same goes to

    123 is in 1423

    541 is in 1425

    544 is in 4458

    So the help I need is for

    Example how to identify and track 3 digit number 235 from a list of 4 digit numbers 1235,2523,1425,4458

    Thank you
    Last edited by bigcrap; 05-08-2011 at 04:41 AM.

  4. #4
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: how to identify only 3 digit permuted number from list of 4 digit number

    bigcrap,

    One last try.


    So that we can get it right the first time:

    Please attach a workbook, with Sheet1.

    Sheet1, column A, beginning in cell A1 (down), will be the list of 4 digit numbers created by you.

    Sheet1, column D, beginning in cell D1 (down), will be the list of 3 digit numbers created by you.

    And, how do you want the numbers in column A to be identified if they contain any of the 3 digit numbers from column D?
    Last edited by stanleydgromjr; 05-08-2011 at 12:02 PM.

  5. #5
    bigcrap
    Guest

    Re: how to identify only 3 digit permuted number from list of 4 digit number

    Thank you very much Stan for replying.

    Is there any way that numbers in column A is highlighted with colour when numbers from column D is identified or is there any other suitable way maybe Stan you can advice me.

    I hope the numbers in column D to be individually checked for example number from column D, 215(D6) checked individually for a match or more from the group of numbers from column A (A1 to A6).

    215 is contained in 1235,1425,2153,5152.

    Thank you
    Attached Files Attached Files

  6. #6
    Forum Expert
    Join Date
    10-10-2008
    Location
    Northeast Pennsylvania, USA
    MS-Off Ver
    Excel 2007
    Posts
    2,387

    Re: how to identify only 3 digit permuted number from list of 4 digit number

    bigcrap,

    Detach/open workbook Identify3In4 - bigcrap - EF774665 - SDG15.xls and run macro Identify3In4.


    If you want to use the macro on another workbook:


    Please TEST this FIRST in a COPY of your workbook (always make a backup copy before trying new code, you never know what you might lose).


    1. Copy the below code, by highlighting the code and pressing the keys CTRL + C
    2. Open your workbook
    3. Press the keys ALT + F11 to open the Visual Basic Editor
    4. Press the keys ALT + I to activate the Insert menu
    5. Press M to insert a Standard Module
    6. Where the cursor is flashing, paste the code by pressing the keys CTRL + V
    7. Press the keys ALT + Q to exit the Editor, and return to Excel
    8. To run the macro from Excel, open the workbook, and press ALT + F8 to display the Run Macro Dialog. Double Click the macro's name to Run it.


    Please Login or Register  to view this content.

    Then run the Identify3In4 macro.
    Attached Files Attached Files

  7. #7
    bigcrap
    Guest

    Re: how to identify only 3 digit permuted number from list of 4 digit number

    A Big Thanks to Stan for your time and effort to solve my problem.

    Everything works fine,except for double digits it show(544 is contained in: 1425,4458), 1425 only contain two digits 4 and 5.I understand that identifying double or triple digits will ruin the formula.

    Anyway the help you had given me already helped me solve most my problems.

    Thank you
    God Bless

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1