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

Community Tip - You can change your system assigned username to something more personal in your community settings. X

Extract row of data based on 2 criteria

Durbal.Andrew.H
10-Marble

Extract row of data based on 2 criteria

I have a table which I want to extract a row which meets 2 criteria. The first is "Threshold" which references the first column and the second is "Threshold2" which references the third column. I have done it in a long winded way, but have managed to highlight the rows that I want to extract individually that partially meet the criteria, but as you can see from the "RowMatch" part, Row 8 is the one that meets both criteria.

How do I compare the matches and pull the row that meets both criteria? As obviously there is more than one row that meets both. Or is there an easier way to do this?

File attached as example.

ACCEPTED SOLUTION

Accepted Solutions

Guess you would need some programming.

Find attached two ways to do it

View solution in original post

3 REPLIES 3

Guess you would need some programming.

Find attached two ways to do it

LucMeekes
23-Emerald III
(To:Werner_E)

I'm sorry I can't see either of your Mathcad documents, being limited to Mcad 11 and below at present.

Here's my attempt.

Success!

Luc

Cheers guys for the examples on this.

Top work and exactly what looking for with some good insight for other possibilities.

Announcements

Top Tags