Checking my lottery numbers
Hello All,
I have the 6 winning numbers in a history file in the format:
3,6,13,22,31,32
10,17,25,30,33,36
I also have the numbers we played in another location in the same
format. (Same file)
The formulas I tried became unmanagable and I could not finish.
Q: Does anyone have a bit of code/macro that will check our numbers
against the history and report if there are 4,5 matches? That is,
tell us if our numbers have won before.
I can modify my data format to suit your code if need be.
Thanks for any help.
Greer
|