Hi,

I have two sets of numerical data that I am trying to match if a alphanumeric criteria is met.

Both ranges are numeric (from and to depth measurements)

The first range is continuous, From_L will always equal the previous To_L

The second range (From_S & To_S) may not be continuous but there will be no overlapping values.

I've noted the From_S - To_S range that meets the criteria in the table - marked with FAIL

Note that the two ranges are variable, the range values will rarely match and they won't often be in the same row.

<tbody>

</tbody>

Any help would be greatly appreciated!!

Thanks

Christian

I have two sets of numerical data that I am trying to match if a alphanumeric criteria is met.

Both ranges are numeric (from and to depth measurements)

The first range is continuous, From_L will always equal the previous To_L

The second range (From_S & To_S) may not be continuous but there will be no overlapping values.

**I need to flag any To_S value that falls within a From_L - To_L range that has the Type LO**

I've noted the From_S - To_S range that meets the criteria in the table - marked with FAIL

Note that the two ranges are variable, the range values will rarely match and they won't often be in the same row.

From_L | To_L | Type | From_S | To_S | ||

0 | 10.5 | 8.0 | 9.0 | OK | ||

10.5 | 11.5 | LO | 9.0 | 10.2 | OK | |

11.5 | 25.6 | QN | 10.2 | 10.9 | FAIL | |

25.6 | 55.1 | VV |

<tbody>

</tbody>

Any help would be greatly appreciated!!

Thanks

Christian

Last edited: