Using Randbetween to generate specific amounts of numbers

**ryanch69** · 07-31-2014, 05:53 AM

Hi,

Im hoping that there is a formula or Excel has an easy way to complete a very tedious task i have to complete.

I have a very long list of names and a number next to them which indicates how many tickets they have.

e.g.
Bob Smith 9
Tom Smith 6

Now, i need to use the =RANDBETWEEN() formula to assign e.g. 9 tickets to Bob Smith, with each ticket number in an individual cell. The second issue i have is that i need my long list of names to have unique ticket numbers (not repeated)

Hope someone can help?

**TheCman81** · 07-31-2014, 05:58 AM

I Think I know what you need however can you upload a sample spreadsheet with expected results

Thanks

**ryanch69** · 07-31-2014, 06:06 AM

Sample.xlsx

File should be attached.

**sktneer** · 07-31-2014, 06:09 AM

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

**ryanch69** · 07-31-2014, 06:26 AM

Hi,

Im hoping that there is a formula or Excel has an easy way to complete a very tedious task i have to complete.

I have a very long list of names and a number next to them which indicates how many tickets they have.

e.g.
Bob Smith 9
Tom Smith 6

Now, i need to use the =RANDBETWEEN() formula to assign e.g. 9 tickets to Bob Smith, with each ticket number in an individual cell. The second issue i have is that i need my long list of names to have unique ticket numbers (not repeated)

I have attached an example of what I am trying to achieve.Attachment 336070

Hope someone can help?

**sktneer** · 07-31-2014, 06:31 AM

Unfortunately this is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed by a Moderator, you may continue in your other thread after changing the thread title as requested.

http://www.excelforum.com/excel-form...ious-task.html

**martindwilson** · 07-31-2014, 06:33 AM

hmm the title has been changed but in the other post..someone needs to sort this out
http://www.excelforum.com/excel-form...rge-scale.html

**sktneer** · 07-31-2014, 06:38 AM

@ ryanch69

Thanks for changing the Thread Title as requested. Thanks for following the forum rules.

**TheCman81** · 07-31-2014, 07:23 AM

I tried this a few different ways and they were all very slow on the processing side.

Attached document is the quickest way I could get it but I think you may have to go down the road of VBA to make it quicker

The tab RAND List contains numbers betweeen 1000-9999 assuming you only want 4 digits

Distribute Rand Tickets.xlsx

**martindwilson** · 07-31-2014, 08:41 AM

quickest i could get with functions was this.. still not that fast tho(edit now i've closed 30 windows of excel it seems to work fine)
very very unlikely to get dupes but it is just possible