Forum Discussion
Excel - Pivot with permutations & combinations
Hello everyone, I've got a problem with excel that I've not managed to solve and search has not been too helpful either since I'm not sure how to put the exact issue into words. I will be inspecti...
If here
entire range under headers (and before count) is named as data, formula could be
=LET(
n, ROWS(data),
ind, SEQUENCE(n),
SCAN(0, ind,
LAMBDA( _, i,
SUM(
BYROW( data,
LAMBDA( line, --AND( SORT( CHOOSEROWS( data, i ), , ,1) = SORT( line , , ,1) ) )
)
)
)
)
)