So i have a VBA script that I'm using to generate all possible combinations using 4 columns of data. The output is needing to be formatted a certain way as well. Currently this is what I have:
It does indeed work to a certain extent, however the issues are that it only seems to return combinations of all 4 columns, when I'd like for it to return combinations using 1-3 columns as well. Essentially like this:Please Login or Register to view this content.
Also, I somehow was able to get 1/2/3 to work, however it keeps adding a / on the end if the combination uses less than all 4 columns which is messing up what I'm using it for. How would I go about generating the combinations without a trailing / ? Any help with this would be greatly appreciated, I've been stuck on it for hours. Thanks!Please Login or Register to view this content.
Bookmarks