I have a list of options which each has a unique value in the form of Power of Two, 0-24 all corresponding to an option:
Power of two options.png
I also have a list with a number, ("Moduler"), corresponding to one or more of these options.
List of options.png
I would like to for each such number break out which options has been set.
I am thinking on the lines of a recursive calclulation in each column, but I am not sure as how to do it properly. Lowest and highest value is fine, but it is the options in between which are difficult.
Any Ideas here?
See attached file "Lisenser_perland_20210128.xlsx" for none sensetive information.
Bookmarks