Find first occurence of a number in an array 7 cols wide
In a lotto analysis spread sheet, I want to find row of the first occurence
of each number (1 to 49) in a 2 dimendional array 7 columns wide--essentially
to find how many spins since the last draw of the number. Can this be done
using functions only e.g. MATCH or do I need to learn VBA quickly?
|