Hi,
I am working with excel as a hobby and creating a lottery checker for fun to gain some experience with excel and its formula's.
I am trying to figure out how to do the following.
I have two tables set up.
In one you have 7 numbers you enter and in another table you have 7 numbers that are drawn. I am trying to figure out how tell excel to compare the 7 numbers drawn to the numbers you entered. If all 7 numbers match, than I want excel to produce a 1. If not I want excel to produce a 0.
Any help is greatly appreciated. Each number is in its own cell so I have 7 cells across.
I am working with excel as a hobby and creating a lottery checker for fun to gain some experience with excel and its formula's.
I am trying to figure out how to do the following.
I have two tables set up.
In one you have 7 numbers you enter and in another table you have 7 numbers that are drawn. I am trying to figure out how tell excel to compare the 7 numbers drawn to the numbers you entered. If all 7 numbers match, than I want excel to produce a 1. If not I want excel to produce a 0.
Any help is greatly appreciated. Each number is in its own cell so I have 7 cells across.