https://www.lotterypost.com/thread/145430 Lottery Post Forum Topic: Finding Pairs with Excel en-us Lottery Post RSS Generator https://www.lotterypost.com/thread/145430/716785 https://www.lotterypost.com/thread/145430/716785 Fri, 24 Nov 2006 03:11:14 GMT Thoth You might consider adding a four more columns to your spreadsheet...a seperate column for each of the three boxed pairs and the fourth to perform the counts.

Do you have the digits separated by position? If so, lets assume that for the first combo you have listed (248) that the 2 is in column C and 4 is in column D and the 8 is in column E....all in the second row. Use the first row as column labels, like date P1 , P2 , P3 .

In column F you can enter: =SMALL(C2:E2,1) SMALL(C2:E2,2

]]> Thoth https://www.lotterypost.com/thread/145430 https://www.lotterypost.com/thread/145430 Fri, 24 Nov 2006 01:55:12 GMT WilliamPhoenix Hey Guys.

I'm trying to find a way of finding pairs within a data series using Excel.

What I have in mind is this. The data is in each column:

1 2 3 4

--------------------------------------------------------------------------------

A 11/01/06 2 4 8

B 11/02/06 6 4 2

C 11/03/06 1 2 4

D 11/04/06 7 7 7

It should output something like 2-4 shows up 3 times.

I tried using COUNTIF and a series of other array f... [ More ]

]]> WilliamPhoenix