Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |