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)
Bookmarks