Forum Discussion

packie's avatar
packie
Brass Contributor
Is there anyone who can help me with this?

The formula provided needs to be dynamic to be of any use because new data is added parodically to the row of data.
Patrick2788's avatar
Patrick2788
Silver Contributor
May 13, 2024

packie 

Another solution:

 

=LET(
    vector, TAKE(DROP(TOROW(6:6, 1), , -1), , -3),
    COUNT(LOG(vector))
)
  • SergeiBaklan's avatar
    SergeiBaklan
    MVP
    May 13, 2024

    Patrick2788 

    Nice idea. Modified a bit if the last number is negative and we shall not to exclude it

    =LET(
    v, TOROW($E6:$ZZ6,3),
    COUNT( LOG(
        TAKE( DROP(v,, @((TAKE(v,,-1)<0)-1)),, -3)
    ) )
)

Resources