Thanks for the great video, Dim! FYI, I found a while back that ISODD and some other functions (can't remember which set of them) need "--" on the array to work dynamically. So that ISODD(H2:Q2) will work as ISODD(--H2:Q2) Good luck in the open!
Good model, Good luck for tonight, and the next round. Thanks for sharing this, I learn a lot about how to design a model. Really great design spread each round to see which dominoes are on board, unused, and draw. 33:48 Again great design, only a few minutes to debug. In my design, I wrap everything in a formula and I only see dominoes on board, It takes HOURS to debug. 23:30 this is not a smart way but just the way I did. I10 =MAX(MODE.MULT(I7:I8,H17:H18)) I17 =IFERROR(IF(H17=I10,H18,H17),H17) I18 =IFERROR(IF(I7=I10,I8,I7),H18)
Can't wait to be able to use vstack, byrow etc (or the Dutch equivalents). At work some of them have appeared already, at home I'm still waiting. I'm learning so much about this type of cases and a/the way to think when solving them.
I know exactly what you mean - the computer I work on at my main client doesn’t have the newest round of functions yet, and I sometimes *really* miss them!
I know you're excited about dynamic arrays and all... but the mind blowing moment for me (which happened in less than a second) was =3-[previous cell] to get 1,2,1,2... SO SIMPLE!
![일상 속 기분 좋음 [Proto disco meme]](http://i.ytimg.com/vi/DwmEIaZ7XGQ/mqdefault.jpg)
Thanks for the great video, Dim! FYI, I found a while back that ISODD and some other functions (can't remember which set of them) need "--" on the array to work dynamically. So that ISODD(H2:Q2) will work as ISODD(--H2:Q2)
Good luck in the open!
Yes! I knew I had read about a workaround at some point, but I couldn’t remember it. Thanks for sharing!
Thanks for sharing Dim. Amazing solution!! Good luck for today!!
Good luck tomorrow Diarmuid! I totally agree... dynamic arrays are AWESOME!
Thanks Erik! Fingers crossed...
Good model, Good luck for tonight, and the next round.
Thanks for sharing this, I learn a lot about how to design a model.
Really great design spread each round to see which dominoes are on board, unused, and draw.
33:48 Again great design, only a few minutes to debug.
In my design, I wrap everything in a formula and I only see dominoes on board, It takes HOURS to debug.
23:30 this is not a smart way but just the way I did.
I10 =MAX(MODE.MULT(I7:I8,H17:H18))
I17 =IFERROR(IF(H17=I10,H18,H17),H17)
I18 =IFERROR(IF(I7=I10,I8,I7),H18)
Ty for that i was stuck at lvl 5. Good luck for the next round
Thanks Diarmuid :)...amazing as always....goodluck today
Thank you! : )
Can't wait to be able to use vstack, byrow etc (or the Dutch equivalents). At work some of them have appeared already, at home I'm still waiting.
I'm learning so much about this type of cases and a/the way to think when solving them.
I know exactly what you mean - the computer I work on at my main client doesn’t have the newest round of functions yet, and I sometimes *really* miss them!
love your videos man, brilliant!
Thank you! It’s always nice to hear people enjoy them.
Thank you Master
Not free any more... pity I wanted to play the game!
I know you're excited about dynamic arrays and all... but the mind blowing moment for me (which happened in less than a second) was =3-[previous cell] to get 1,2,1,2... SO SIMPLE!
Yes! I don't know how long I spent doing that kind of thing with IF before it clicked that there was a better way! : )
And my MOD approach :D