Working with Binary numbers BASE(..., 2, 7) and bit operations BITXOR, BITAND

PeterBartholomew1 

Looks like a nice approach, I'd like to make time to check this out in more detail. It does makes me think a lambda function for generating combinations, like the one in Python, would make for a useful utility function and worth looking at as a future challenge.

On the subject of more obscure functions, I have seen specialised financial functions such as DOLLARFR and even ODDFYIELD employed in the context of treasury yield computations. Bitwise functions are also fairly niche in my experience but become more useful in lambda development where one is looking to optimise algorithms for example replacing array comparisons with bitwise operations. One application I have found myself reusing on multiple occasions is in generating (pseudo-)random data but removing volatility e.g. for benchmarking or speeding up recalc

=LAMBDA(length, [seed],
    TAKE(
        SCAN(
            IF(ISOMITTED(seed), 123456789, seed),
            SEQUENCE(length, , , 0) * {13, -17, 5},
            LAMBDA(s, i, BITXOR(s, BITAND(BITLSHIFT(s, i), 2 ^ 32 - 1)))
        ),
        ,
        -1
    )
)(5)

ref: https://en.wikipedia.org/wiki/Xorshift