Excel Formula- combinations

SHT

Member
Excel Experts,

I was wondering if it would be ok to request an excel formula.

Basically I have a spreadsheet of past lottery results and I require an excel formula to enable me to determine the frequency of repeating pair combinations in my lottery data. Would anyone be able to help me?

The lottery has 49 balls and 6 balls and the bonus ball are drawn. I have a lottery table with all lottery results in ( Columns B:H ).

COLUMNS

A ________B______C ____etc....

date&____1st No__2nd No__etc....
draw no 500

Thanks in advance

SHT.



:cold:
 
Top