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
=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.
- Can we use OFFSET function or any BIT operation as well ?
Br,
Anupam
