Impressive solve! Was the keyboard setting in solidarity with Andrew’s almost-elimination in the semi-final? ; ) 4:24 That slow calc is because it’s doing the concat for all 1M+ rows… a good use case for tables! 😁 (Funnily enough, you noticed the same thing at 10:35) 18:04 I know you can do it super fast, but every time I see you do MAP / IFERROR / ROWS / FILTER instead of COUNTIFS, I die a little inside! 😂 Also, I noticed when you go to a different sheet, come back, and click on a cell, the reference doesn’t include the sheet name by default. Is that a setting you can change? The sheet name getting added might be the feature that makes me swear under my breath more often than any other… 25:42 I couldn’t possibly do a case like this without tables!
Haha...no, I currently switch regularly between the US and German keyboards - that brings a bit of variety, because both keyboards are quite different... 4:24...yeah, I should be more cautious about calculation speed/time (I'm currently working on my Lambdas for that matter) 18:04 As for IFS, I really need to get my head around the difference between arrays and ranges... sometimes I struggle with simple COUNTIFS under pressure - so I'm leaning more towards FILTER + formula combinations at the moment...always with the thought that you'll cry if you see me do it like this😂 ...and I have not changed any settings regarding the sheet name...no idea where that comes from 😂
![Lp. Сердце Вселенной #60 РОЖДЕНИЕ ЛОЛОЛОШКИ [Финал] • Майнкрафт](http://i.ytimg.com/vi/YoR0pAV9FVQ/mqdefault.jpg)
Impressive solve! Was the keyboard setting in solidarity with Andrew’s almost-elimination in the semi-final? ; )
4:24 That slow calc is because it’s doing the concat for all 1M+ rows… a good use case for tables! 😁 (Funnily enough, you noticed the same thing at 10:35)
18:04 I know you can do it super fast, but every time I see you do MAP / IFERROR / ROWS / FILTER instead of COUNTIFS, I die a little inside! 😂
Also, I noticed when you go to a different sheet, come back, and click on a cell, the reference doesn’t include the sheet name by default. Is that a setting you can change? The sheet name getting added might be the feature that makes me swear under my breath more often than any other…
25:42 I couldn’t possibly do a case like this without tables!
Haha...no, I currently switch regularly between the US and German keyboards - that brings a bit of variety, because both keyboards are quite different...
4:24...yeah, I should be more cautious about calculation speed/time (I'm currently working on my Lambdas for that matter)
18:04 As for IFS, I really need to get my head around the difference between arrays and ranges... sometimes I struggle with simple COUNTIFS under pressure - so I'm leaning more towards FILTER + formula combinations at the moment...always with the thought that you'll cry if you see me do it like this😂
...and I have not changed any settings regarding the sheet name...no idea where that comes from 😂