View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Bob is offline
external usenet poster
 
Posts: 972
Default Finding last column in range

Please forgive what may appear to be a stupid question, but is there a way to
tell Excel to search in reverse (i.e., right to left) in a formula such as:

=OFFSET(C10,0,MATCH(MAX(C10:N10)+1,C10:N10,1)-1)

In other words, have cell N10 examined first, followed by cell M10, followed
by cell L10, etc.?
Thanks,
Bob