Results 1 to 4 of 4

Thread: New Help Creating A Formula

  1. #1

    New Help Creating A Formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello -

    One of my clients sent me a database and cells in one column looks like this:

    BL: 954966747
    40RE MMAU1247216 40RE MNBU0032486 40RE MNBU0041981 40RE MNBU0078656

    40RE MNBU0090712 40RE MWCU5226151 40RE MNBU0106172 40RE PONU4947868



    Bear in mind that the data above is all in one cell. I need to count how many times 4 letters is succeeded by 7 letters such as PONU494786. These 4letter/7number keys indicate a single container. The answer to the example above is 8. However, each cell in the column contains a different amount of containers and I have like 20000+ rows. Is there a way to count the amount of containers in a cell when the data comes in like above ^.

    Thank you!

  2. #2
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    887
    Articles
    0
    Excel Version
    Excel 2013
    Quote Originally Posted by Jameslowrey10 View Post
    These 4letter/7number keys indicate a single container. The answer to the example above is 8.
    I guess this is my made solution is not the best. But if no one answer to you, maybe this can help.
    I think that VBA can be more helpful. See attached file example
    Attached Files Attached Files
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

  3. #3
    Quote Originally Posted by navic View Post
    I guess this is my made solution is not the best. But if no one answer to you, maybe this can help.
    I think that VBA can be more helpful. See attached file example
    Thankyou!!!!

  4. #4
    Magician navic's Avatar
    Join Date
    Aug 2013
    Location
    Europe, Croatia
    Posts
    887
    Articles
    0
    Excel Version
    Excel 2013
    You're welcome
    My personal Web Excel Tutorials
    Attention! In the formulas as a delimiter I use a semicolon (; ) if you using my formula, then perhaps you need to use a comma (,)
    Also for a decimal number I use a comma (,) you may need to use point (.) instead of

Tags for this Thread

Posting Permissions

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