Minimum/maximum in matrices

[Dumitru]

I need to find for each column of a matrice the minimum value (> 0) in that column (pos_6 as defined by the attached ; the maximum is obtained by using "max" function..). Please help!

Kind regards, D.

[StuartBruff]

Dumitru Moldovan wrote:

I need to find for each column of a matrice the minimum value (> 0) in that column (pos_6 as defined by the attached ; the maximum is obtained by using "max" function..). Please help!

Kind regards, D.

Dumitru,

I'm not quite sure the attached will do what you want, but I've created a function, minnz, that hunts for the minimum nonzero number. Do you require it to specifically look for the minimum positive number of just the least number > 0?

Stuart

[Dumitru]

It's about finding the minimum positive number foe each column in the matrice...Thanks for the attached. I'll take a look into it.

[MagnusEklund]

Or if your matrices aren't really big maybe you can use something like this:

Regards,

Magnus

[StuartBruff · Accepted solution]

Dumitru Moldovan wrote:

It's about finding the minimum positive number foe each column in the matrice...Thanks for the attached. I'll take a look into it.

OK, Dumitru. Try the attached worksheet with function minnzpos1.

Stuart

[Dumitru]

Dear Stuart, thank you for both your sheets. You answered my question.

Kind regards, D.