how to excel some results

[ᶦ ᵃᵐ|Ä-łëx]

Ok.. the first repeat we have that's a set and , end there.. but on the next row i need to start from the new number and not repeating the pattern like that ...

[Bigbroben]

Voila

[ᶦ ᵃᵐ|Ä-łëx]

Almost there.. i need Bothe repeater on each set .. so the last number is the repeater

[Bigbroben]

Repeater is in front of nr serie.


P.S.  It always ends up at -2.7%.

[ᶦ ᵃᵐ|Ä-łëx]

BBB its simple but i don't know to  code it...
I need the first one exactly  not the second..
Its ok anyway

[ᶦ ᵃᵐ|Ä-łëx]

does anyone knows the formula  to count the empty spaces from 1 every time a new empty cell start..?

[Bigbroben]

OK, if on cell D6:
=IF(B6="";"";1+C6)

[ᶦ ᵃᵐ|Ä-łëx]

Thank you BBB ..

[ᶦ ᵃᵐ|Ä-łëx]

If i have only the 0 and the 1 does the formula change?

[ᶦ ᵃᵐ|Ä-łëx]

?

[Bigbroben]

Change "" for 0

[ᶦ ᵃᵐ|Ä-łëx]

like this..

[Bigbroben]

Like this.

[ᶦ ᵃᵐ|Ä-łëx]

If you can make it so the zeros don't show at all only , but it ok yes

[leoncino74]

ecco...