If I enter 1-5 in Calc, what function returns 1,2,3,4,5?

[veggienae]

I have a spreadsheet that tracks money raised by students for a fundraiser. Among other things, the sheet calculates how many entries into the prize drawing each student receives. Students earn up to 20 entries.
I now need to assign a number to each drawing entry, so we can use RANDBETWEEN to pick the winners. Is there a function or macro that would allow me to type 1-5, but populate the field with 1,2,3,4,5? Even better would be an option that uses the last number of the previous entry and the number of entries earned to complete the sheet automatically. The first 68 students were calculated manually in about an hour resulting in nearly 700 drawing entries. There are another 232 students to do. Any time saving functions or macros would be appreciated.
I am using 4.2.2 for OSX.

ADDITIONAL INFO: The sheet calculates the number of entries in the Ticket column based on money raised. Each entry must be assigned a unique number for the drawing in the Ticket Numbers column. Currently, we have to input the numbers manually, but I was wondering if there was a way to shortcut that data entry and to ensure that there are no mistakes, such as double assigning a number or not giving a student enough entries.

For example, if Student A earns 5 Tickets, then the Ticket Numbers entered would be 1 2 3 4 5.
Then, if Student B earns 8 Tickets, the Ticket Numbers entered would be 6 7 8 9 10 11 12 13.
And, if Student C earns 12 Tickets, the Ticket Numbers entered would be 14 15 16 17 18 19 20 21 22 23 24 25.

[oweng]

I do not understand what problem you are attempting to solve. Please edit your question to provide an example of a student entry i.e., the type of data to be input (are the “1” and “5” coming from cell references?) and the expected output. Thanks.

[mahfiaz]

What a way to solve a problem

Make it a little simpler. Let’s say you have the following data:

Name,     Votes, Ticketstart
StudentA, 3,      1
StudentB, 5,      4 =C1+B1
StudentC, 7,      9 =C2+B2
Total:   15 votes

Now get a random number between 1 and 15, CEILING(RAND()*15, 1) and look up the name of participant who would own that ticket.

Edit: thanks, @oweng