View Single Post
  #3   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?

On Sep 21, 11:44 pm, "T. Valko" wrote:
wrote in message
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?


Try this array formula** :
=MATCH(MAX(IF(A1:A10<=C1,A1:A10)),A1:A10,0)


Perfect! Thanks.