Finding Maximum in Matrix under side condition

[sm�ller-2]

Hallo guys,

i have a question regarding finding a maximum value out of a matrix.

I have an overlap , maximum transmissible force, NOKOK Matrix

i now need to find the overlap for the maximum transmissible force under the condition "OK"

The values in the matrix are only valid for "OK"

For the given example the correct overlap is 0,127 mm with 649,736 kN

Can anyone help me out how to determine this problem?

I have Mathcad 15

Thank you Br Stefan

[LucMeekes]

Use the csort () function twice. First on the NOKOK column, then on the force column.

Success!
Luc

[Werner_E]

---

For the given example the correct overlap is 0,127 mm with 649,736 kN

---

Why?? What about 0,121 mm with 655,656 kN ??

[Werner_E]

Is it this what you are looking for:

[Werner_E · Accepted solution]

And here is a more classic, straightforward approach using a loop. Again w/o using an augmented matrix.

It works without using match,trim, max and lookup.

It's your choice now.

[sm�ller-2]

yes you are correct!

[sm�ller-2]

Thank you for the help!