Forum Discussion
MOTI
Dec 29, 2024Copper Contributor
FUNCTION
HELLO I look for function that will show me all the combinationes of 4 numbers in excell BEST REGARDS
- Dec 30, 2024
m_tarler
Dec 30, 2024Bronze Contributor
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),"")
)