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.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Ticket Entries[/TD]
[TD]Number[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]10[/TD]
[TD]1-10
[/TD]
[/TR]
[TR]
[TD]Lisa[/TD]
[TD]5[/TD]
[TD]11-15[/TD]
[/TR]
</tbody>[/TABLE]

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.


[TABLE="width: 500"]
<tbody>[TR]
[TD]Name[/TD]
[TD]Tickets[/TD]
[TD]From[/TD]
[TD]To[/TD]
[TD]Output[/TD]
[/TR]
[TR]
[TD]John[/TD]
[TD]10[/TD]
[TD]1[/TD]
[TD]=B2[/TD]
[TD]=C2&"-"&D2[/TD]
[/TR]
[TR]
[TD]Lisa[/TD]
[TD]5[/TD]
[TD]=D2+1[/TD]
[TD]=D2+B3[/TD]
[TD]=C3&"-"&D3[/TD]
[/TR]
</tbody>[/TABLE]