Index and Match function for having maximum and minimum values

[RAFIQUE MUNDE]

I am trying to find out the maximum and minimum values in Index and Match function
For example
Nodes Sign Moment
1 +ve 54
1 +ve - 10
1 - ve 68
1 - ve - 15
1 +ve 25
1 +ve - 25
1 - ve 49
1 - ve - 56

Here, we have two values (criteria) to return the final value.

I am using above formula to return the value of moment.
{=INDEX(A2:C9, MATCH(A11&B11, A2:A9&B2:B9, 0),3)}

The final answer comes = - 10

I need minimum of the above values and my answer should come - 56.
Please help me how to use Max and Min conditions to find out the maximum and minimum values.

 

[jorismoerings]

Hi Rafique,

I can't see with the entering of 2 criteria how you're able to reach a solution of -10; The criteria to do so would require an extra variable because with variable "1" and sin "+ve" your formula with combined criteria will return 54 instead of -10. The answer of -56 from your sample comes from variables "1" and sign "-ve". Could you elaborate?

 

[Mathias Pedersen Heinze]

I don't understand what you are trying to do? If you just want the minimum value of column C, you could just use

=MIN(C1:C9)