Tom Ogilvy wrote:
Think you need to reread the specification Patrick. He doesn't want
the
index in the range, he wants the count of cells back to the previous
occurance of the value or to the start of the range.

1) Tom has interpreted my post correctly.

You could certainly build such a formula using a VBA UDF, however,
since you
blasted this to several groups, including programming, it is unclear
whether
a VBA UDF would be an acceptable solution.

2) VBA UDF would be an acceptable solution, hence the reason I
cross-posted to microsoft.public.excel.programming.
3)I don't do blasting.

You want the function to return an array of values even though this
can't be
displayed in single cell?

4) Tom that is why you are the expert, and I am the novice. The whole
point of posting, is for you to tell me if it is possible.

Regards

James