Using the Power of two to find which options are selected in a recursive fashion

Originally Posted by J_Andreas_Lindqvist

the power of two is nothing I can change, that is how the options are structured in the source

Good choice, IMHO. But that is limited to 53 options.

(Excel does not format the sum with option 2^50, 2^51 and 2^52 correctly. But they are accounted for correctly.)

Enter the following into D2 and copy across into E2:T2:

=IFERROR(IF(ISODD(INT([@Moduler]/2^(MATCH(D$1,'VB Moduler'!$A$1:$Y$1,0)-1))),1,""),"")

The structured Table automagically copies the formulas down their respective columns.