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
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,164,090
Messages
5,835,337
Members
430,351
Latest member
ddalton

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