Hi,
I have a similar small question and also need help. (Please "Save As" to MC12).
Finding the (unique) Minimun and Marking. (like as above)
Thanks in advance.
Regards, -LL-
Solved! Go to Solution.
Something like the attached?
The functions are not dependant on both matrices.
Mike
Message was edited by: Mike Armstrong - worksheet updated
Are you wanting to show the min and max comparing both matrices or for each array?
Mike
Mike, searching through both matrix. (and NOT for each array). And the Output like as above. (This's only my intuition). And the max for option.
Loi.
Something like the attached?
The functions are not dependant on both matrices.
Mike
Message was edited by: Mike Armstrong - worksheet updated
Mike, you're right. My intuition was failed. And I have learned a lot from your comment and your worksheet.
Thanks for your time.
Regards, -LL-
Thanks for your time.
No problem at all.
I have re-wrote both functions so they iterate through both matrices. There are pre-defined functions within the program, but I don't see that as an issue. Maybe someone else (betteprogrammer) can write a more efficient version - my bed time now
One last thing - it doesn't handle multiple min and max values. It will only indicate the first value found.
Mike
Mike Armstrong wrote:
Thanks for your time.
No problem at all.
I have re-wrote both functions so they iterate through both matrices. There are pre-defined functions within the program, but I don't see that as an issue. Maybe someone else (betteprogrammer) can write a more efficient version - my bed time now
One last thing - it doesn't handle multiple min and max values. It will only indicate the first value found.
Here's a variant, based upon the use of a common function, that will mark multiple occurences of the same value ...
Stuart
Here's a variant, based upon the use of a common function, that will mark multiple occurences of the same value ...
Nice neat function. I was trying for ages to get something similar to work, with no avail.
I wouldn't say its a variant though - more of a replacement.
Cheers
Mike
Slight variation of Stuart's function. Will now look through both matrices.
Mike