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

Find matching Value

muser
14-Alexandrite

Find matching Value

HI Help with finding matching values:

 

muser_0-1634263330425.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
Werner_E
24-Ruby IV
(To:muser)

See if the attached file helps!

 

You may replace the "R" after "if k>=O" by "csort(R,O)" if that suits your need better.

 

View solution in original post

7 REPLIES 7
Werner_E
24-Ruby IV
(To:muser)

See if the attached file helps!

 

You may replace the "R" after "if k>=O" by "csort(R,O)" if that suits your need better.

 

View solution in original post

muser
14-Alexandrite
(To:Werner_E)

Thank you for that. How can I also choose one that does not match?

Werner_E
24-Ruby IV
(To:muser)


@muser wrote:

Thank you for that. How can I also choose one that does not match?


Not sure what you mean???

All the combination of two indices which are NOT in the list my program return correspond to values which are farther apart than the tolerance given.

Werner_E
24-Ruby IV
(To:Werner_E)

Here is a shorter version of the above with a third function argument.

If the last argument is 1, the function works as the one given above, returning the indices of all pairs which are closer or equal to "tol".

If the third argument is 0, the function returns the indices corresponding to all pair of vector elements which are farther apart than "tol".

Not sure if thats what you had in mind.

 

muser
14-Alexandrite
(To:Werner_E)

What I meant was:

muser_0-1634506417505.png Select 1000

 

muser_1-1634506479266.png

select 4000

 

 

LucMeekes
23-Emerald I
(To:muser)

Like this?

LucMeekes_0-1634508137144.png

Success!

Luc

muser
14-Alexandrite
(To:LucMeekes)

Elegant!

 

I think I may also be able to use an outlier function.

Announcements
Check out the latest
Mathcad Tip
"PTC Mathcad 15 / Prime 1-6 Update."