excel and pick 3

Reply #2

amberwaves43 — Thu, 10 Aug 2017 22:18:51 GMT

Thanks Allen-I solved it by reverting to a trifecta box in horse racing and just assigned different cells to it, producing 6 tickets combos

Reply #1

AllenB — Thu, 10 Aug 2017 17:59:53 GMT

When searching out boxes, the easiest way is to convert the box to LMH (Low-Medium-High) Order. You then only have 220 Boxes to look for. Order is only applicable to straights.

I have done this in a few of my workbooks.

If this is what you are looking for let me know and I will put something together for you.

excel and pick 3

aquarian1000 — Wed, 02 Aug 2017 16:48:37 GMT

I have been wracking my brain to come up with a formula to check pick 3 numbers against the numbers drawn to determine if they are straight or boxed.

Straight isn t a problem boxed is!! no matter what formula I sue it always gives me a box on numbers that dont match.

HELP!

Bob