Thanks,

I'll try that one too.


"Herbert Seidenberg" wrote:

This array formula finds the row of the
last occurrence of Target in MyArray
=MAX((MyArray=Target)*ROW(MyArray))