Advent of Code 2015 Day 17: No Such Thing as Too Much using Excel

Advent of Code 2015 Day 17: No Such Thing as Too Much using Excel

correction SEQUENCE(2^n) should be SEQUENCE(2^n-1)
BASE(SEQUENCE(2^n-1),2,n)

eg 1-8 base 8 is 1000
001
010
011
100
101
110
111
1000
we take the first 3 digits 8 = 100_0 duplicate with 4 = 100
2^n-1 to get rid of the last number

=LET(z,B3#,n,ROWS(z),MMULT(--MID(BASE(SEQUENCE(2^n-1),2,n),SEQUENCE(,n),1),z))

[DimEarly]

I think I'm going to try to make LAMBDAs of some of your amazing AOC functions before this weekend's FMWC round... I have a feeling they might be helpful on the Solver question! : ) That one to get all the ways to sum to N with X numbers from a set was nice!