lottery best performing triad

[nodwas]

I wonder if anyone could help me, what i trying to do is work out the best performing triad the comes out from my lottery history. finding one is i guess easy. but when it comes to best performing pair i'm at a loss. if anyone could please help . i would be most greatful. or if you high light the triads(number i place in 3 cell.

 

[ukmikeb]

Hi

Welcome to the forum.

You refer to "triad" which I am assuming is the combination of 3 numbers (1,2,3.. 4,5,6.. etc) and later you refer to "pairs" (1,2.. 2,3.. etc).

May I suggest that the basis of both calculations would be a grid based on each draw where the drawn numbers are represented by 1 and the non-drawn numbers by zero. So, if your Lottery has 49 numbers then this grid will be 49 by the number of draws.

Pairs -

For this you will need a 49 by 49 grid and a suggested formula -

=IF(Row_Lottery_No = Column_Lottery_No,"",SUMPRODUCT(--(Entire_Column_Row_Lottery_No=1),--(Entire_Column_Column_Lottery_No=1))

The end result will be a grid with a diagonal line of blanks cells with the totals of the pairs replicated above and below the diagonal.

Triads -
In a sheet you will need to generate the triad combinations 1,2,3.. 1,2,4...1,2,49, 1,3,4..1,3,5....1,3,49...etc and the suggested formula will be along the lines -

=SUMPRODUCT(--(Entire_Column-Selected_NumberColumn1=1),--(Entire_Column-Selected_NumberColumn2=1),--(Entire_Column-Selected_NumberColumn3=1))

Good luck

hth