Ticket Entry to Number Assignment

[imsleepless]

Hello, I was wondering if there is a formula on excel to do what I am trying to do:

Example: Lets say John and Lisa was entered into a draw, John has 10 tickets and Lisa has 5.

Name	Ticket Entries	Number
John	10	1-10
Lisa	5	11-15

<tbody>
</tbody>

So my excel would look like this except when it comes to the number assignment I have to type it manually. Is there a function that will automatically update that number after I put the number of entries?

Thanks for your help in advanced.

 

[steve the fish]

Place this in C2:

=SUM($B$1:B1)+1&"-"&SUM($B$1:B2)

Copy down

 

[imsleepless]

Thank you so much, life saver!

 

[petertenthije]

I would split it up in two columns, one with start number and one with end number.
Copy for formula in row "Lisa" down as far as needed.

Name	Tickets	From	To	Output
John	10	1	=B2	=C2&"-"&D2
Lisa	5	=D2+1	=D2+B3	=C3&"-"&D3

<tbody>
</tbody>