use match from the bottom to the top.

[kang]

the match function gives the index from the top
is it possible to use match from the bottom to the top?
ie. the meaning of "=MATCH(A1,$A$8:$A$1,0)"

 

[Guest]

You can do =counta($A$8:$A$1) - MATCH(A1,$A$8:$A$1,0) or count() if you're
using numbers.

 

[Guest]

But what if some cells in the range are empty? Try

=ROWS($A$1:$A$8)-MATCH(A1,$A$8:$A$1,0)+1

 

[kang]

thanks daddylonglegs.
what if I want to get the last instance of the match cell?

 

[kang]

I don't want the first instance of the matched cells be indexed from the
bottom, but, I want the last instance of the matched cells.