I want Excel to automatically update the number list based on the quantity of tickets each associate paid for.Example: Doug buys 3 tickets and Mike buys 5 tickets The raffle list now looks like: 1 Doug 2 Doug 3 Doug 4 Mike 5 Mike 6 Mike 7 Mike 8 Mike Then Sally buys 1000 tickets so 1000 tickets are added to the list, making 1008 the total number of tickets sold.This would update the list automatically if I entered 1000 for Sallys name, thus duplicating her name 1000 times in the list.How can I do this automatically in excel so I wont have to use a calculator and do it manually.
Tambola Ticket Excel Update The NumberWhen I randomize all the numbers (say 1,008) at the end of the raffle, I want their number to be by their name. Example: Doug bought 3 tickets Mike bought 5 tickets Sally bought 1,000 tickets so the list looks like: 1 Doug 2 Doug 3 Doug 4 Mike 5 Mike 6 Mike 7 Mike 8 Mike 9-1008 Sally (but listed out) Then if I go to randomizer.org and randomize 1 set of unique numbers 1-1008 and lets say a 50 is rolled, then Sally would be the winner and further down on the list it would say: 49. Sally 50. Sally - W i n n e r 51. I have 200 people that have purchased a total of 50,000 tickets so this is a pickle of a problem. If you create your own thread, any advice will be tailored to your situation so you should include a description of what youve done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread. For a better experience, please enable JavaScript in your browser before proceeding. ![]() Can someone help me replace the random numbers generated in the fabulously written excel sheet - with the content I want. I mean, if I have numbers 1 - 90 in Column A and customised text against these cells in Column B, then how can I generate tickets and replace the content of the cells in one action I tried to CopyPaste Special (values) to separate sheet and use VLOOKUP (after reading few tricks on the site) BUT (1) this seems to be a manualmechanical process if I want hundreds of such tickets (2) more frustratingly, the blank cells return a NA error. Also want to have an option if it is possible to keep only 6 columns (instead of 9 in the generator sheet) and have only 1-60 numbers instead of 1-90 with random 4 numbers (instead of 5) in each row - of course keeping the basic rule of a housie game intact of generating numbers 1-10 in 1st column, 11-20 in 2nd column, 21-30 in 3rd and so on, in ascending order. ![]() I have uploaded my attempted file) Thanks a bunch in advance. Alternatively, in the sheet that chandoo created, you could take his formulas and put it inside the VLOOKUP, so you dont need to copypaste. I jumped out of my seat on seeing the errors vanish by just by entering the formula in two cells. I still cant understand the structure of the formula you suggested to avoid the copypaste. Do you suggest I edit the formula in the cells in Chandoos sheet itself and place it within VLOOKUP - after keeping the NewList (lookup and returning values) somewhere in his sheet Or vice versa Thanks in advance Amit.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |