Create a randomly generated list with 1 from each strata

Amberman

New Member
Joined
Dec 25, 2015
Messages
7
Hi all

I am a bit stuck on this one. I have a filtered table of sporting events with dates and times. I have also manually allocated intervals to the events so that there is at least 3 hours between intervals (so I am only betting on one sporting event at a time an my accumulator bet)

Table columns are:

Interval | Date | Start Time | Event | Price

Im trying to create Xn combinations of events randomly to measure the combined price of the 5 fold or 6 fold bet, with no more than one event from each period, sorted by date, then time.

Im not at all sure how to do this. Any help would be appreciated.

Thanks in advance

Amberman
 

Some videos you may like

Excel Facts

Will the fill handle fill 1, 2, 3?
Yes! Type 1 in a cell. Hold down Ctrl while you drag the fill handle.

Watch MrExcel Video

Forum statistics

Threads
1,122,463
Messages
5,596,284
Members
414,051
Latest member
tabecker

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top