Skip to main content
D
Dumitru1-Visitor
1-Visitor
February 23, 2011
Solved

Minimum/maximum in matrices

  • February 23, 2011
  • 1 reply
  • 5491 views

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.

Best answer by StuartBruff

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

1 reply

S
StuartBruff23-Emerald V
23-Emerald V
February 23, 2011

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

D
Dumitru1-VisitorAuthor
1-Visitor
February 23, 2011

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.

M
MagnusEklund12-Amethyst
12-Amethyst
February 23, 2011

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

colmingt0.png

Regards,

Magnus

Terms & ConditionsAccessibility statement