| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to add conditions to Match function?
Does anyone have any suggestions on how to add conditions to Match function?
I get 4 numbers under the cell A1:A4, and I would like to determine which number under cell A2:A4 is larger than cell A1 and closer to A1, such as Those numbers are 10[A1], 17[A2], 20[A3], 13[A4], then the number 13 should be return in cell B1 in this case. On the other hands, if all numbers under A2:A4 are smaller than A1, then returns the max number A2:A4 in cell B1. Does anyone have any suggestions? Thank you in advance Eric |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to add conditions to Match function?
What if a number is equal to A1? What result would expect in that case?
A1 = 10 A2 = 17 A3 = 20 A4 = 10 What if all the number are the same? Biff "Eric" wrote in message ... Does anyone have any suggestions on how to add conditions to Match function? I get 4 numbers under the cell A1:A4, and I would like to determine which number under cell A2:A4 is larger than cell A1 and closer to A1, such as Those numbers are 10[A1], 17[A2], 20[A3], 13[A4], then the number 13 should be return in cell B1 in this case. On the other hands, if all numbers under A2:A4 are smaller than A1, then returns the max number A2:A4 in cell B1. Does anyone have any suggestions? Thank you in advance Eric |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to add conditions to Match function?
Those numbers are 10[A1], 17[A2], 20[A3], 10[A4], then the number 10 should
be return in cell B1 in this case. I would like to determine which number under cell A2:A4 is larger than cell A1 and closer to / equal to A1. Do you have any suggestions? Thank you for any suggestions Eric "T. Valko" wrote: What if a number is equal to A1? What result would expect in that case? A1 = 10 A2 = 17 A3 = 20 A4 = 10 What if all the number are the same? Biff "Eric" wrote in message ... Does anyone have any suggestions on how to add conditions to Match function? I get 4 numbers under the cell A1:A4, and I would like to determine which number under cell A2:A4 is larger than cell A1 and closer to A1, such as Those numbers are 10[A1], 17[A2], 20[A3], 13[A4], then the number 13 should be return in cell B1 in this case. On the other hands, if all numbers under A2:A4 are smaller than A1, then returns the max number A2:A4 in cell B1. Does anyone have any suggestions? Thank you in advance Eric |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lookup with INDEX MATCH formule depending on 2 conditions | Excel Worksheet Functions | |||
| index match array function-returning only first match, need last. | Excel Worksheet Functions | |||
| Match as well as does not match array function | Excel Discussion (Misc queries) | |||
| How do I sum numbers that match two conditions? | Excel Worksheet Functions | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
Linear Mode
