View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
kang kang is offline
external usenet poster
 
Posts: 38
Default use match from the bottom to the top.

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)"