use match from the bottom to the top.

  • Thread starter Thread starter kang
  • Start date Start date
K

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)"
 
You can do =counta($A$8:$A$1) - MATCH(A1,$A$8:$A$1,0) or count() if you're
using numbers.
 
But what if some cells in the range are empty? Try

=ROWS($A$1:$A$8)-MATCH(A1,$A$8:$A$1,0)+1
 
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.
 
Back
Top