Forum Discussion
Formula to count a row, reset if 3 values found within last 24 days, display count since reset
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 Since Reset F F F F DO DO F F F DO F F DO F F F 3 So using the basis of the table above, I am trying to come up with ...
This is a solution for Excel 365:
=LET(
TotalDays, LAMBDA(each_row,
LET(
k, COUNTIF(each_row, "DO"),
split, TEXTAFTER(CONCAT(each_row), "DO", -1, , , ""),
IF(k >= 3, LEN(split), "")
)
),
BYROW(grid, TotalDays)
)
Hey Patrick,
Thank you for the quick response, I tried to implement your formula and sometimes it is correct, others it is off, so not sure where it is going wrong?
I notice that if I go through and change values to change the count then start from 0 days off then go back and change values it seems to count correctly after that
Do you have a sample workbook you're able to share?
Sorry Patrick,
Was on days off there.
Please find attached an example book, ask if you have any questions
