Forum Discussion
BITPOSITION
Dear Experts, Could you please share the formula, on how to Extract the Bit-position of k0,k1,k2,k3 in below excel. Thanks in Advance, Br, Anupam
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)))