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.
|