View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] nomail1983@hotmail.com is offline
external usenet poster
 
Posts: 58
Default How to find largest value "<=" when array is in descending order?

MATCH(...,1) returns the position of the largest value less than or
equal to the lookup value when the lookup array is sorted in asceding
order.

Is there a standard Excel function or standard Excel add-in that
returns the position of the largest value less than or equal to the
lookup value when the lookup array is sorted in descending order?

I know I can write a VBA function. And there might be non-standard
add-ins -- that is, add-ins that are not distributed with Excel. But
I prefer to use a standard Excel function or standard Excel add-in.