how to excel some results

[alexlaf]

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

[alexlaf]

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%.

[alexlaf]

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

[alexlaf]

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)

[alexlaf]

Thank you BBB ..

[alexlaf]

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

[alexlaf]

?

[Bigbroben]

Change "" for 0

[alexlaf]

like this..

[Bigbroben]

Like this.

[alexlaf]

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

[leoncino74]

ecco...