Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Function to find 'n'th largest alphanumeric field (like "Large") | Excel Worksheet Functions | |||
"Type mismatch" when I try to fill an Array variable with "+" | Excel Discussion (Misc queries) | |||
How do I use "offset" function in "array formula"? | Excel Discussion (Misc queries) | |||
How to change the default in Excel from "find next" to "find all" | Excel Discussion (Misc queries) | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) |