Snasui Excel Forum

Hi Dear,
I need your help how to write a formula to cope with start and end number in excel.

I attach a file

Thank in advance

Hi Guy

Which column(s) that you need to place the formula (C D E)?

Norkaz

..

Quite not sure what you need to place the formula(s).

However, try this.


D2
=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($A$2:$A$22)/($A$2:$A$22+1<>$A$3:$A$23),ROWS($D$2:D2))),LOOKUP(9^9,$A$2:$A$23))

C2
=INDEX(A:A,IFERROR(MATCH(D1,$A$2:$A$23,0),0)+ROW($A$2))

E2
=D2-C2

If it does not match your requirement, please provide more explanation.

Norkaz

thank you