Hi Domenic,

Thank you so much for your endeavours.

For robustness...
D1:

=ROWS(Values)-MATCH(TRUE,MMULT(--(ROWS(Values)-(ROW(Values)-MIN(ROW(Value
s))+1)+1<=TRANSPOSE(ROW(Values)-MIN(ROW(Values))+1)),Values)=C1,0)+1
...confirmed with CONTROL+SHIFT+ENTER.

Cheers,
Sam


Domenic wrote:
For robustness...

D1:

=ROWS(Values)-MATCH(TRUE,MMULT(--(ROWS(Values)-(ROW(Values)-MIN(ROW(Value
s))+1)+1<=TRANSPOSE(ROW(Values)-MIN(ROW(Values))+1)),Values)=C1,0)+1

...confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

Shorter...

[quoted text clipped - 6 lines]

Hope this helps!


--
Message posted via http://www.officekb.com