I am analyzing how many months since last purchase from client. Clients are in the row and columns are the months. I have the exact formula I need; the only thing is that it doesn’t analyze from right to left. So instead of counting blank cells since last purchase it is counting blank cells up to first purchase.
Current formula: =MATCH(FALSE,ISBLANK(C7:L7),0)-1
I tried to play around with adding in index as well as offset formulas but it seems as if these formulas are used more for cross analyzing columns and rows. Please Help!
>Solution :
Something like this:
=TAKE(SCAN(0,A2:H2,LAMBDA(a,b,IF(b<>"",0,a+1))),,-1)
Result:
