Great tutorial! I'm starting to stay away from ArrayFormula and trying to stick with newer LAMBDA functions to be more compliment to Excel (though it's sometimes painful to work in Excel :). Something similar would be =CHOOSEROWS(D2:D6,ROUND(REDUCE(0,B2:B8,LAMBDA(acc,cur, acc+XLOOKUP(cur,D2:D6,E2:E6)))/COUNTA(B2:B8),0)) Just to add in a bunch of formulas :)
![Gucci Mane & Sexyy Red - You Don't Love Me [Official Music Video]](http://i.ytimg.com/vi/j7IBqyFKT4c/mqdefault.jpg)
Great tutorial! I'm starting to stay away from ArrayFormula and trying to stick with newer LAMBDA functions to be more compliment to Excel (though it's sometimes painful to work in Excel :). Something similar would be =CHOOSEROWS(D2:D6,ROUND(REDUCE(0,B2:B8,LAMBDA(acc,cur, acc+XLOOKUP(cur,D2:D6,E2:E6)))/COUNTA(B2:B8),0)) Just to add in a bunch of formulas :)
Thank Daniel. Great alternative.
I actually a small tutorial in the pipeline using CHOOSEROWS.