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

Community Tip - When posting, your subject should be specific and summarize your question. Here are some additional tips on asking a great question. X

Finding the Minimun and Marking.

lvl107
20-Turquoise

Finding the Minimun and Marking.

Hi,
I have a similar small question and also need help. (Please "Save As" to MC12).

(A,B).PNGMarkUniqueMinOR.PNG

Finding the (unique) Minimun and Marking. (like as above)
Thanks in advance.
Regards, -LL-

1 ACCEPTED SOLUTION

Accepted Solutions
MikeArmstrong
5-Regular Member
(To:lvl107)

Something like the attached?

The functions are not dependant on both matrices.

Mike

Message was edited by: Mike Armstrong - worksheet updated

View solution in original post

8 REPLIES 8
MikeArmstrong
5-Regular Member
(To:lvl107)

Are you wanting to show the min and max comparing both matrices or for each array?

Mike

lvl107
20-Turquoise
(To:MikeArmstrong)

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.

MikeArmstrong
5-Regular Member
(To:lvl107)

Something like the attached?

The functions are not dependant on both matrices.

Mike

Message was edited by: Mike Armstrong - worksheet updated

lvl107
20-Turquoise
(To:MikeArmstrong)

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-

MikeArmstrong
5-Regular Member
(To:lvl107)

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

MikeArmstrong
5-Regular Member
(To:StuartBruff)

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

MikeArmstrong
5-Regular Member
(To:lvl107)

Slight variation of Stuart's function. Will now look through both matrices.

Mike

Top Tags