View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gunti Gunti is offline
external usenet poster
 
Posts: 58
Default Searching from bottom to top with MATCH?

Hi,

I'm using MATCH to find a value in an array. B2:B35000

However, there are multiple matches. Right now it takes the first value it
finds (from B2 to B35000). Can i tell excel to get the latest MATCH? (Search
from 35000 to B2).

gr,
Gunti