P
Paul Black
Hi everyone,
I have a table of lottery numbers where 6 balls are drawn each draw.
The table is from D3:i whatever and obviously grows constantly.
The draw number is in column B with the last draw at the bottom.
What I would like is to list the numbers from 1 to 49 starting in S3
and going down and next to each number have the number of draws since
that particular number has been drawn please. So basically, start at
the bottom right cell of the table and work left and then up to find
out how many draws it has been since each of the numbers from 1 to 49
have been drawn.
Thanks in advance.
Paul
I have a table of lottery numbers where 6 balls are drawn each draw.
The table is from D3:i whatever and obviously grows constantly.
The draw number is in column B with the last draw at the bottom.
What I would like is to list the numbers from 1 to 49 starting in S3
and going down and next to each number have the number of draws since
that particular number has been drawn please. So basically, start at
the bottom right cell of the table and work left and then up to find
out how many draws it has been since each of the numbers from 1 to 49
have been drawn.
Thanks in advance.
Paul