+ Reply to Thread
Results 1 to 11 of 11

Lower and Uppercase combination

  1. #1
    Registered User
    Join Date
    09-28-2010
    Location
    NYC
    MS-Off Ver
    Excel 2003
    Posts
    4

    Lower and Uppercase combination

    Hello,

    I've read a handful of threads on here regarding combination, but my challenge is a bit different.

    I have 9 characters, i know the order the need to appear in, however, i need the different upper and lower case combinations.

    Here are the characters AND in the correct sequence:

    upper or lower case "g"
    upper or lower case "r"
    upper or lower case "o"
    upper or lower case "o"
    upper or lower case "v"
    upper or lower case "e"
    upper or lower case "n"
    upper or lower case "y"
    upper or lower case "c"

    Note that the "o" needs to be repeated in the string.

    Does anyone know how to plug this into Excel with the appropriate formulas and get all the possible combinations?

    Thank you in advance,
    James
    Last edited by jameshiller; 09-28-2010 at 10:51 PM.

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Lower and Uppercase combination

    What do you mean by all possible combinations? GrovenNYC?

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    Re: Lower and Uppercase combination

    There could 2^8 or 256 possible combinations if the order is kept as you suggested.

  4. #4
    Registered User
    Join Date
    09-28-2010
    Location
    NYC
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Lower and Uppercase combination

    Let me try to clarify.

    I need all possible combination for the following letters:

    g,r,o,o,v,e,n,y,c

    each letter can be either upper case or lower case, but must appear in that order.

    Does that help?

  5. #5
    Registered User
    Join Date
    09-28-2010
    Location
    NYC
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Lower and Uppercase combination

    it would be 2^9... however, i need to display all possible combination in excel not just arrive at a number.

  6. #6
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Lower and Uppercase combination

    essentially its binary 000000000 to 111111111 i think so perhaps this 0-512
    Attached Files Attached Files
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  7. #7
    Registered User
    Join Date
    09-28-2010
    Location
    NYC
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Lower and Uppercase combination

    Thank you so much martindwilson! This is exactly what i was looking for.

  8. #8
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: Lower and Uppercase combination

    here's a 8 bit version as requested by prince_of_swan
    Attached Files Attached Files
    Last edited by martindwilson; 08-17-2012 at 07:51 AM.

  9. #9
    Registered User
    Join Date
    08-17-2012
    Location
    Lahore,Pakistan
    MS-Off Ver
    Excel 2007
    Posts
    1

    Re: Lower and Uppercase combination

    Thank you

  10. #10
    Registered User
    Join Date
    01-04-2020
    Location
    NY
    MS-Off Ver
    2019
    Posts
    1

    Re: Lower and Uppercase combination


    This is great!
    to do this with 10 letters instead of the 9 listed how do I modify this document?

  11. #11
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,929

    Re: Lower and Uppercase combination

    Quote Originally Posted by abearch View Post
    This is great!
    to do this with 10 letters instead of the 9 listed how do I modify this document?
    Administrative Note:

    Welcome to the forum.

    We are happy to help, however whilst you feel your request is similar to this thread, experience has shown that things soon get confusing when answers refer to particular cells/ranges/sheets which are unique to your post and not relevant to the original.

    Please see Forum Rule #4 about hijacking and start a new thread for your query.

    If you are not familiar with how to start a new thread see the FAQ: How to start a new thread
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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