Forum Discussion

5 Replies

  • m_tarler's avatar
    m_tarler
    Bronze Contributor
    Dec 30, 2024

    if you want a solution that isn't a macro you can try:

    =LET(in, A1:A7, 
         n, ROWS(in), 
         c, SEQUENCE(n)*SIGN(BITAND(SEQUENCE(1, 2 ^ n),  2 ^ SEQUENCE(n, 1, 0))),
         IF(c,INDEX(in,c),"")
         )

     

    • MOTI's avatar
      MOTI
      Copper Contributor
      Dec 30, 2024

      HI

      I dont understand.

      could you send a file with an example ?