I have a list of different items listed in Column A along with its Lower and Upper bound values in Column B & C respectively.
I need to generate all possible permutations and enumerate them in different columns as shown in the image.
Permutations.JPG
Is there any plugins or Macro Codes available to do the above function?
Maybe :
Please Login or Register to view this content.
1. I care dog
2. I am a loop maniac
3. Forum rules link : Click here
3.33. Don't forget to mark the thread as solved, this is important
In D1, put the formula =C1 and drag down to C4
In E1, put the formula =IF(D2>=$C2,IF(D1>=$C1,$B1,D1+1),D1) and drag it down and right as far as needed.
Note that C5 needs to be empty.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks