Forum Discussion
Formula Needed
I have a need for a formula which allows in the left row A the numbers 1, 2, 3, etc, to be displayed, reflecting the sum of all prior entries in row B plus one. The excel sheet would look like this: ...
Try this one:
=LET(
r, XMATCH(TRUE, ISTEXT(B:B), , -1),
words, TAKE(B1:B100000, r),
AutoNum, LAMBDA(element,
LET(
keep, ROW(element),
number, COUNTIF(TAKE(words, keep), "*"),
IF(ISBLANK(element), "", number)
)
),
MAP(words, AutoNum)
)