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