Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to determine the value?
Does anyone have any suggestions on how to determine the value?
There is a list of values under column A 191,189,183,177,175,171,167,165,155,153,151 There is given numbe in cell B1, 177 I would like to display 175 in cell C1, which is maximum number within the list less than 177. Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to determine the value?
Hi,
Try something like this =MAX(IF(A1:A10<C1,A1:A10,"")) This formula is an array so press Shift+Ctrl+Enter to enter it. If this helps, please click the Yes button. -- Thanks, Shane Devenshire "Eric" wrote: Does anyone have any suggestions on how to determine the value? There is a list of values under column A 191,189,183,177,175,171,167,165,155,153,151 There is given numbe in cell B1, 177 I would like to display 175 in cell C1, which is maximum number within the list less than 177. Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to determine the value?
=MAX(INDEX((A1:A11<B1)*A1:A11,))
Just press ENTER "Eric" wrote: Does anyone have any suggestions on how to determine the value? There is a list of values under column A 191,189,183,177,175,171,167,165,155,153,151 There is given numbe in cell B1, 177 I would like to display 175 in cell C1, which is maximum number within the list less than 177. Does anyone have any suggestions? Thanks in advance for any suggestions Eric |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to determine the max. value? | Excel Worksheet Functions | |||
How to determine the max. value? | Excel Worksheet Functions | |||
How to determine the value? | Excel Discussion (Misc queries) | |||
How to determine the value? | Excel Discussion (Misc queries) | |||
How to determine the value? | Excel Discussion (Misc queries) |