Home |
Search |
Today's Posts |
#1
|
|||
|
|||
maximum value in a list less than specified value
I'm in dire need of help, i'm at the final stage of a large project and i'm
stuck on the final hurdle, which almost seems easy to do but i cant do it. I have a list of data and all i need to do is extract from the list the closest value either equal to or less than a value i specify. So to be simple i have a list of numbers say; 10, 20, 30 ,40 and i say which number is less than or equal to 35 so it would display the figure 30. I know i can do it under a filter but just need it to be automatic as the list of data changes and will just display the one number in a cell i pick. Any help will save my remaining hair from being pulled out. Thank you |
#2
|
|||
|
|||
try something like
=index(range,match(30,range,1)) "DBYRON" wrote: I'm in dire need of help, i'm at the final stage of a large project and i'm stuck on the final hurdle, which almost seems easy to do but i cant do it. I have a list of data and all i need to do is extract from the list the closest value either equal to or less than a value i specify. So to be simple i have a list of numbers say; 10, 20, 30 ,40 and i say which number is less than or equal to 35 so it would display the figure 30. I know i can do it under a filter but just need it to be automatic as the list of data changes and will just display the one number in a cell i pick. Any help will save my remaining hair from being pulled out. Thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filtered list & maximum no columns problem | Excel Discussion (Misc queries) | |||
LOOP - Adddress List -to email | Excel Discussion (Misc queries) | |||
Refresh a Validation List? | Excel Discussion (Misc queries) | |||
Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
maximum size of a Microsoft Excel list for a pivot table | Excel Discussion (Misc queries) |