FORMULA EXPLAIN

[sohaila]

Can anybody explain this fomrula

REDUCE(0,H7:H10,LAMBDA(a,b,VSTACK(TAKE(a,1),a+b)))

h7 1
h8 2
h9 3
h10 4

result
0
4
7
9
10

thanks

[sohaila]

Please help

[DocAElstein]

Hello sohaila
Welcome to ExcelFox
I am sorry that nobody has been able to help you yet.
I don’t recognise most of the functions in that formula. I think they are only available in a newer version of Office such as 365 subscription, which I do not have.

We don’t have many formula experts passing excelfox currently.

Perhaps you could try here,
https://www.excelforum.com/excel-for...and-functions/

and / or if you have Office 365 you could try here
https://www.excelforum.com/office-365/



Alan