Great video,clearly and well explained.Thank you.

Excellent! I've never used scan and reduce functions. Thank you for this class!

Awesome! Thank you so much for this tutorial!

I was waiting for the part where you would say what are the benefits of scan, reduce, map. I expect it is connected with sorting. Thank you!

Great video content!

I need to do this but with a condition to run per day 1 to last of the month bases on Month ID. I will crack my head cuz you already took me half way! Thanks lottle! Love the way you explain everything ❤️

This is fantastic! Learned a lot! Which would I use if I need to move rows often (move a row or add/delete a row) and want the running total to stay the same based on the new order?

Just Perfect ...Many Thanks

Excellent explanation. I saw a formula LinkedIn that uses the reduce function to reverse text string and I don't understand the logic behind it. I will then use scan to see how it works. Thanks for this tip

Awesome

Thanks for the video. I understand how the formulae work but the question when to use one over the other one, for example, map vs scan vs regular method.

Great

We can use relative references in dynamic array formulas; you don't need to fix the cell row as you did (B$2) in the running total.

Oh my! This class was absolutely AMAZING, an unprecedented great learning experience! Let me ask you, in a simple formula that I use the filter passing a reference that I want to bring from another tab, I usually do this frequently, but when I update the base via sql that I pull using the appscript I need to drag the formula again, this it's very annoying, I tried to reproduce your majestic teaching with arrays, but I still don't see how to do it with a filter when I want to bring data from another tab with a relationship key. Could you guide us with a video about array with filters, that would be very helpful! Great teaching video, I leave here my sincere gratitude!

👍💯

How would you do a running balance if you have Deposits in one column and Withdrawals in an adjacent column, both reported as positive values?

In this case REDUCE() could be replace with a simple SUM() or SUBTOTAL(). How is REDUCE() useful in other contexts?

If you had a ledger with both income and expenditure columns, and you wanted a running total, could these functions be used to create an array formula for that situation?

Teacher, can the SCAN Function work with the OFFSET Function?

These 2 examples using Scan and Reduce are simple examples. It will be more practical if you can provide us with more practical examples like using them in Loan Amortization Table or Depreciation table, in addition to Makearray (). Thanks

Teacher, when you were in the Womb, did your mom work with lots of Spreadsheets?

this is great info, but I have a scenario that I can't seem to solve for.. I need to running total to work when I filter out rows. It works when all rows are viewed, but everything i,ve tried fails to correctly calculte only visible rows if filtered. I need to see the running total after every transaction filtered. Any thoughts?

How if cumulative sum only the same data in column A

Awesome scholastic venture on how to complicate things, should that be the purpose 🙂 But why not simply apply Occam's razor and settle with =sum($B$2:B2) and/or =ArrayFormula(sum($B$2:B)) ?

i have a question. did google stole these functions from microsoft or microsoft stole these from google ? or is there some international convention ?😅😅