These functions are a real spectacle. They change the way of thinking. Great video.
@user-hj4kk2lt6w Жыл бұрын
Действительно - очень нужный и красивый метод применения функции Lambda
@Scoofnie4 ай бұрын
Always the best videos for google sheets and excel, thank you!
@nadermounir8228 Жыл бұрын
This is an amazing explanation 👏. The best explanation of the reduce function I have seen on KZbin so far.
@FunSpiritman2 жыл бұрын
Thanx for explaining all these great Excel functions (MAP, BYROW, BYCOL, REDUCE, and LAMBDA). I use Google sheets more than Excel. We can only hope Google will implement some of these useful functions soon (like they did with SEQUENCE and FLATTEN). Maybe you can show a Google Apps Script version of some of these functions.
@jonathansmith77772 жыл бұрын
Google Apps Script Reduce already exists
@FunSpiritman2 жыл бұрын
@@jonathansmith7777 Great... I'll look for it. Thanx.
@jonathansmith77772 жыл бұрын
@@FunSpiritman Let me give you an example. From time-to-time my Google sheets pass the 5 million cell limit and run into trouble. So I wrote a script to loop through all the tabs and determine the cell counts. Then these are stored in an array. Reduce allows me to get a sum of all the counts function sheetSizeDeterminator(){ var ss = SpreadsheetApp.getActiveSpreadsheet(); var sheets = ss.getSheets() var size = 0 var total = [] sheets.forEach(function(sheet){ size = sheet.getMaxColumns()*sheet.getMaxRows() total.push(size) Logger.log(sheet.getSheetName() + " Size: " + size) }); Logger.log("Total size is: " + sumArray(total)) } // sum values in an array function sumArray(array) { return array.reduce (function(previous,current) { return previous+current; },0); }
@deegobooster Жыл бұрын
These functions are now available on google sheets
@damian4601 Жыл бұрын
The examples are good but there are shorter alternatives without Lambda. =Sum(B3:B14) and =RegexReplace(A2,"[;,.>]","")
@yamilvogeld.238511 ай бұрын
Dude thank you soooo much!! This video is GREAT... changed my brain
@pino678211 ай бұрын
Hi. thanks for the video! I would suggest naming x or changinvalue as "accumulator", or "acc" instead. I think the name it describes well its purpose and clearly distinguishes the input coming from the collection (array) and accumulator as the value that keeps track of the intermediate calculations (state).
@a.achirou65478 ай бұрын
Thank you !
@elricho722 жыл бұрын
Great Video.
@rrrraaaacccc80 Жыл бұрын
Excellent 💯👍
@ExcelGoogleSheets Жыл бұрын
Thanks ✌️ It's nice to know that some people appreciate these really good videos that don't get much attention. I think these functions are just too complicated for most spreadsheet users.
@kamelgamal26052 жыл бұрын
I need your help , please How can I give the Form Responses this order? If you find a duplicate answer from the same email in two different lines, give me his last answer
@helenz7485 Жыл бұрын
Thank you so much!
@ExcelGoogleSheets Жыл бұрын
👍
@JoseAntonioMorato Жыл бұрын
I really liked the explanation, but there is no need to drag down the formula as you can select the entire range of categories: =REDUCE(A2:A9;{";";"-";",";".";">";":"};LAMBDA(changingvalue;r;SUBSTITUIR(changingvalue;r;""))) 🤗
@ExcelGoogleSheets Жыл бұрын
Sure, but I like to stay on topic when I make videos.
@maxp6066 Жыл бұрын
Good video but do you need to use the reduce function how about just using LAMBDA and SUBSTITUTE on their own.