cancel
Showing results for
Did you mean:
cancel
Showing results for
Did you mean:

SOLVED
Marble

## Finding Maximum in Matrix under side condition

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?

Thank you Br Stefan

1 ACCEPTED SOLUTION

Accepted Solutions

## Re: Finding Maximum in Matrix under side condition

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.

6 REPLIES 6

## Re: Finding Maximum in Matrix under side condition

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

Success!
Luc

## Re: Finding Maximum in Matrix under side condition

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 ??

## Re: Finding Maximum in Matrix under side condition

Is it this what you are looking for:

## Re: Finding Maximum in Matrix under side condition

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.