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.
This question generated 28 answers. To proceed to the answers, click here.
This thread is current as of November 02, 2013.