D
dkenebre
How can I express a formula that would back 300 rows and look at every
other row for the 3 cells with random single digits from 0 to 9 and
calculate, the how many rows back since the oldest 0-9 digit occurred
in cell 1 answer, cell 2 answer and 3 answer, then calculate which 0-9
digit has not occurred in cell 1, cell 2 and cell 3 the longest and
displays how many row back since the last occurrence.
So that would be 4 separate formulas
other row for the 3 cells with random single digits from 0 to 9 and
calculate, the how many rows back since the oldest 0-9 digit occurred
in cell 1 answer, cell 2 answer and 3 answer, then calculate which 0-9
digit has not occurred in cell 1, cell 2 and cell 3 the longest and
displays how many row back since the last occurrence.
So that would be 4 separate formulas