It doesn't surprise me anymore, Momoh, everything is yours _ _ _ _!!!
@IvanCortinas_ES
Жыл бұрын
One more example of how to convert the resolution of a complex case into the sum of several less complex cases. The logic used is excellent. Thank you Victor.
@ExcelMoments
Жыл бұрын
I appreciate your comments , as always. And your point on a complex problem being equivalent to multiple simple problems is very apt
@oscarmendez-roca9181
Жыл бұрын
Great video as always Victor, very creative solution. I allow me to share my proposal solutions: For the Sum of last N non-blank: =BYROW(C3:H10,LAMBDA(r,SUM(TAKE(TOROW((1/r)^-1,2),,-I1)))) And for the conditional format: =ISNUMBER(XMATCH("Attempt "&XMATCH(C3,$C3:$H3),"Attempt "&XMATCH(TAKE(TOROW((1/$C3:$H3)^-1,2),,-$I$1),$C3:$H3)))
Пікірлер: 8