I have a a 2016 spreadsheet that has seven columns of lottery numbers with 100 rows. I can't figure out how to generate a formula that will tell me the number of times a value repeats itself (or doesn't repeat itself) moving down from row to row, or drawing to drawing. As an example, suppose a number repeats itself in several consecutive games, or hasn't repeated itself for a certain number of games. How do I generate a formula that will tell me this?
Thanks very much for your help in advance.