Can Excel find box number https://www.lotterypost.com/thread/315053 Lottery Post Forum Topic: Can Excel find box number en-us Lottery Post RSS Generator Reply #2 https://www.lotterypost.com/thread/315053/5241171 https://www.lotterypost.com/thread/315053/5241171 Mon, 04 Sep 2017 22:45:55 GMT Raven62 They say that using Index Match are faster than using Vlookup.

]]> Raven62 Reply #1 https://www.lotterypost.com/thread/315053/5241163 https://www.lotterypost.com/thread/315053/5241163 Mon, 04 Sep 2017 22:29:18 GMT AllenB It is called the LMH Box. It is the Digits in Low-Med=Hi Order.

You need to convert The Straight to L-M-H Then You can Do Your Search.

Here is a Table of all 1000 Straight Combinations with The Corresponding LMH Box

You could put this into your Excel File and Access it with a Vlookup Function

Straight N1 N2 N3 Box

000 0 0 0 000

001 0 0 1 001

002 0 0 2 002

003 0 0 3 003

004 0 0 4 004

005 0 0 5 005

006 0 0 6 006

007 0 0 7 007

008 0 0 8 008... [ More ]

]]> AllenB Can Excel find box number https://www.lotterypost.com/thread/315053 https://www.lotterypost.com/thread/315053 Thu, 31 Aug 2017 23:56:36 GMT choua01 I personally enter all daily 3 number into excel, so i need to find past numbers but execel can only find the past wining numbers in straight position. Does any body know if there is a formula to get execel to find past wining number in box format. If not than I will have to go back and roll all past winning number but it will takes years to complete. Thanks guys.

]]> choua01