Forum Discussion
priyanksharma
Nov 26, 2021Copper Contributor
Dynamically Need to find out minimum value of each row after summation of multiple columns.
Hi I may not be very clear in describing subject. However I will try my best to elaborate issue here. I have to calculate minimum for each week and as we move to next week minimum should be calcul...
SergeiBaklan
Nov 26, 2021Diamond Contributor
If to wait lambda helper functions which are so far available for insiders only
=MIN( BYROW( $E4:I8, LAMBDA(r, SUM(r) ) ) )- priyanksharmaDec 01, 2021Copper ContributorHi Sergei, Thanks for your input. Definitely I am looking forward to try this function. However , Hans suggestion has worked fine for me.