BITPOSITION

anupambit1797 

First, I converted your DEC2BIT result to an array with:

=1*MID(B2,SEQUENCE(,LEN(B2)),1)

 Then the formula for bit position:

=LET(filtered,FILTER(BITPosition,C2#<>0),r,COLUMNS(filtered),INDEX(filtered,,SEQUENCE(,r,4,-1)))

anupambit1797 

=INDEX($C$1:$J$1,LARGE(IF($C$2:$J$2=1,COLUMN($C$2:$J$2)),COLUMN(A$1))-2)

You can try this formula. Enter the formula with ctrl+shift+enter as an arrayformula if you don't work with Office365 or Excel 2021.

Hi

Try this

=LET(m,(C1:J1+1)*C2:J2,SORT(FILTER(m,m>0),,,TRUE)-1)

anupambit1797