How to use the Excel SCAN function (for running totals and more)

preview_player
Показать описание
Рекомендации по теме
Комментарии
Автор

Gracias, es un punto de vista muy poderoso el que das en este video. Sorry, My English is not good.

ExcelHechoFacil
Автор

SCAN seems very similar to LIST.ACCUMULATE in Power Query.

brianxyz
Автор

Does this negate the need for recursive lambdas or are there things you can do with a recursive lambda which can't be done here?

HadynWiseman
Автор

Where can I find xl files from the competition?

Mishkafofer
Автор

So glad you made this video - I know basic SCAN/REDUCE (cumulative aggregation) but keen on using it like Bo and yourself in more complex ways

HussainAliNasser
Автор

What does your training consist of? I'm just trying to sleep well, don't get anxious and hope for the best. I've already reached my goal of qualifying. I'm glad that I'm done at 10:15 AM my time 😀
Break a formula/lambda for your games!

sledgehammer-productions
Автор

Now that you tackle lambda helpers,
would really love to have your explanation of the MAP function.

nytsiory
Автор

If only I have only 1/3 of your knowledge in excel!!!! :) :)

johnborg
Автор

Woot, I learned a new function! Can't wait to compete Saturday!

nemoyatpeace