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 :)
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.