+ Reply to Thread
Results 1 to 7 of 7

Need help with a combintion of 5 things that have multiple parts

  1. #1
    Registered User
    Join Date
    06-05-2018
    Location
    Illinois
    MS-Off Ver
    Excel
    Posts
    2

    Need help with a combintion of 5 things that have multiple parts

    first excel.PNG
    So I have 5 things that go together. They are a model number MR-J3-BC that stays the same, the 2 digits 101 and 102 that can be either in the line, a blank space or a 4, a blank space and 9 different 2 letter combinations, and a blank space or 3 alphanumeric characters in any combination (though it's actually 3 or MORE but I don't want to kill anymore here.) What I need to do in excel is find all possible combinations with these 5 characters and put them in excel. I have little to no experience with excel so I am expected to do this all by hand, I don't want to give myself carpal tunnel syndrome at age 19 so can anyone help me?
    From the pic you see the (starting from column N) 1. The model number that remains the same, 2. The number 101 or 102, 3. a blank or a 4, 4. a blank and 9 2 letter combinations (you only see blank atm because of the massive combo of 5) 5. 3 alphanumeric characters in any combination (this is what is killing me and apparently have over 20k combos)
    Last edited by P^3; 06-05-2018 at 03:32 PM. Reason: to keep the rules

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Need help with a combintion of 5 things that have multiple parts

    Welcome to the forum!

    Will you please attach a sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

    1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

    2. Make sure that your desired results are also shown (mock up the results manually).

    3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

    4. Try to avoid using merged cells as they cause lots of problems.

    Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

    Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Need help with a combintion of 5 things that have multiple parts

    You edited your opening post, but have not provided the workbook I requested. Please do so. A picture of it is of little or no use.

  4. #4
    Registered User
    Join Date
    06-05-2018
    Location
    Illinois
    MS-Off Ver
    Excel
    Posts
    2

    Re: Need help with a combintion of 5 things that have multiple parts

    what is a workbook?

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,369

    Re: Need help with a combintion of 5 things that have multiple parts

    An Excel file. You have shown us a picture of it - please attach the Excel file instead.

  6. #6
    Forum Expert azumi's Avatar
    Join Date
    12-10-2012
    Location
    YK, Indonesia
    MS-Off Ver
    Excel 2019
    Posts
    2,360

    Re: Need help with a combintion of 5 things that have multiple parts

    A workbook is your excel file with your detail explanation and your expected results, Click on "Go Advanced" button and scroll down find the "Manage Attachment text button to attaching your file
    Last edited by azumi; 06-05-2018 at 05:19 PM.

  7. #7
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,005

    Re: Need help with a combintion of 5 things that have multiple parts

    Paperclip does not work!

    See Ali's instruction in post #2

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Can a macro sum multiple things to multiple criteria?
    By lwilt in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-07-2015, 10:14 AM
  2. [SOLVED] Sum the value for things with multiple criterias
    By ponx in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 10-10-2015, 01:03 AM
  3. [SOLVED] Using Data tables when there are MULTIPLE things that can change
    By rikkyshh in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-30-2013, 03:07 AM
  4. Search for multiple things at once
    By MDW in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-28-2013, 11:44 PM
  5. [SOLVED] Single cell doing multiple things?
    By cause in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-06-2013, 11:50 PM
  6. [SOLVED] Counting multiple things
    By babalurugby in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-03-2012, 09:55 AM
  7. Making a command(macro?) to do multiple things
    By rdubya in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-31-2007, 05:19 PM

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