Formula to Issue share Numbers

[amos.a]

We have 100 share holders in our compnay we want to issue share certificates to them, each members can hold a minimum of one share and a maximum of ten shares, we want to insert share numbers to them in their certificates

eg member A is holding 5 shares so the number will be 1-5, and then member B is holding 3 shares so the number will be 6-8 and member C is holding 2 shares so the number will be 9-10, what is the formula pls help me

uploaded a sample worksheet for reference

 

[Hui]

Amos.a

Firstly, Welcome to the Chandoo.org Forums

C2: =TEXT(SUM($B$1:$B1)+1,"#0")&IF(B2=1,,"-"&TEXT(SUM($B$1:$B2),"#0"))

Copy down