Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 01-09-2017, 11:31 AM
victor222 victor222 is offline Random Sequencing Windows 10 Random Sequencing Office 2010 64bit
Novice
Random Sequencing
 
Join Date: Jan 2017
Posts: 3
victor222 is on a distinguished road
Default Random Sequencing

Hello all,

I am looking for help with this vba problem i have.

I have a system that accepts 3 types of demand in bulk. Each bulk has quantities in it. I have been able to split this quantities randomly from 1 to 5 splits before going into the system sequencially. But now i want these splits to go in a random sequence with no same type following each other.
For example

Type 1: 5 quantities; splitted into 2,3
Type 2: 7 quantities; splitted into 3,4
Type 3: 6 quantities; splitted into 1,1,1,1,2

And they go into the system in that sequence: 2,3,3,4,1,1,1,1,2

But i want to sequence to be random with no two of the same type following each other.

Please how can I achieve this with code.



Thanks
Reply With Quote
 

Tags
random sequence, vba



Similar Threads
Thread Thread Starter Forum Replies Last Post
Random with Kurtosis ramesh31 Excel 0 02-18-2016 03:45 AM
Sequencing duplicates balajigade Excel Programming 3 10-04-2015 03:31 PM
Random Sequencing Random Name Generator knp11 Word 1 01-18-2015 11:41 AM
Random indentation Galahad Word 1 09-25-2013 11:05 AM
random pop up wont go away 464646 OneNote 0 05-01-2012 04:34 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:54 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft