Minimum/maximum in matrices
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Minimum/maximum in matrices
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.
Solved! Go to Solution.
- Labels:
-
Other
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Or if your matrices aren't really big maybe you can use something like this:
Regards,
Magnus
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Dear Stuart, thank you for both your sheets. You answered my question.
Kind regards, D.
