I've been using the following formula

=MATCH(a3,"649history!d:d"),0)-3

to determine when the last hit was for the value found in cell a3 for example the reason for the -3 at the end is becuase i have 2 rows of column headers and if a number hit in the last draw i want to record a 0.

But what my question is I can't figure out how to manipulate this formula to continue the skip count to create in effect a skip chart showinghow many rows since that occurance backwards until it finds the next occurance.

It gets even worse as the formula won't work for a number in any position as the match formula will get screwed up over more than 1 column.

Any ideas? Thanks

Grayth