Many thanks also for saying lambda helper functions are slow.
I do not know if "slow" is the right, fair word for it. I think I found a better way to describe it.
Imagine the elevators in a super tall skyscraper building. They are all the same make, they use the same infrastructure of rails, mechanics, and electronics.
Some of them, the regular ones, can be programed to access any floor, and some of them can be programmed to acces every other 20 floors, the express ones,
When they are moving, they are equally fast.
If the only task is to get to the 20th floor, take the express, if you take the regular you risk stopping on each floor even if no information is getting in, no information is getting out.
Waste of resources, looks and feels slow.
At the end of the day, the regular ones (lambda helpers), when really needed, can carry more complex information for complex tasks, outperforming the express ones.
One question while we are at topic of efficiency, I notice sometimes these functions is much faster than the other:
- OFFSET is faster than INDEX to retrieve value from large array.
- XLOOKUP is faster than INDEX-MATCH.
- XMATCH is faster than MATCH in ordered array.
Are all of these generally true? What do you think?
Speed test results are very contextual. It is not complicated to construct your own tests. The only thing you have to consider is to compare binary with binary, exact with exact.
INDEX-MATCH binary can be lot faster than XLOOKUP exact. Golden rule: Whenever you can sort always use binary lookups of any function you like.
And any reason you use QUOTIENT instead of INT?
Personal thing, I felt sorry for the quotient function that nobody uses it. MOD and QUOTIENT are brothers, they have same parents (identical arguments). In my functions/formulas they will never be separated.
Yeah, sorry I couldn't find your functions before I post this.
As I said before, you do not have to find or follow anything. This new Excel ecosystem is new to all of us. It is too early to develop any stereotypes. Have an idea you believe in, go for it.
Think of it as a library. You do not need to read any books to write your own novel.
more important than the function itself.
Regarding the function, I am planning to explain better the concept behind ACOMB and all combinatorics calculations, on future posts, but probably not here.
There is a simple formula/function that is the main core of solving any combinatorics problem, permutations, combinations, combinations of n vectors...etc
fn(n,c)=LAMBDA(n,c,MOD(ROUNDUP(SEQUENCE(n^c)/n^(c-SEQUENCE(,c)),0)-1,n)+1)
