Shorter...

D1:

=ROWS(Values)-MATCH(TRUE,MMULT(--(ROWS(Values)-ROW(Values)+1<=TRANSPOSE(R
OW(Values))),Values)=C1,0)+1

....confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!

In article ,
Domenic wrote:

Hi Sam!

After looking at this again, I've come up with another formula to
replace the first one, which I believe is more efficient...

D1:

=ROWS(Values)-MATCH(TRUE,MMULT(--(LARGE(ROW(Values),ROW(Values)-MIN(ROW(V
alues))+1)<=TRANSPOSE(ROW(Values))),Values)=C1,0) +1

...confirmed with CONTROL+SHIFT+ENTER.

Hope this helps!