Forum Discussion

Copper Contributor

Jun 19, 2022

Solved

Need Formula or Data Table usage on Collecting Data

Hello, I'm working on a database to find patterns in a lottery, based on frequencies of combinations in the previous drawings. My table has 3 columns: Ball 1, Ball 2, and Pairs. Ball 1 and Bal...

excel

dscheikey
Jun 19, 2022
TeeTom
I have created a sample file. Is that what you meant?

Example

A second Example with an alternative pair calculation.

dscheikey

Bronze Contributor

Jun 19, 2022

TeeTom

I have created a sample file. Is that what you meant?

Example

A second Example with an alternative pair calculation.

TeeTom
Copper Contributor
Jun 19, 2022
Thanks for the example table, it was very similar to mines. I eventually figured it out and the solution bothers me as much as the problem.

The issue was the Data Table function was able to do what I needed to do, but only if the table was on the same sheet as the database with the drawings.

Thanks for the effort on it as well, one of us might hit a jackpot with these Excel skills. 🙂