Hi Everyone,
i am trying to match values from list 2 to match with list 1 (list values are length in mm)
Condition to match values is
- value should be equal to or lest than equal to -20mm
- or the closet value
and get the matched list.
If anybody has tried something similar kindly share your ideas , drop a link.
Thank you so much.
to make it more clear –
if considered
list_1 =x and list_2 = y
Condition to match values is
match y values to x
match the closet value , closest value should be be more than +20mm
and get the matched list.
If anybody has tried something similar kindly share your ideas , drop a link.
Thank you so much.
Hi,
You can do it like that.
1 Like
@patrykrosi
thank you for your quick response,
referring to my image in first post -
list 1 has 40 values
list 2 has 22 values
i have to match list 2 values with list 1
condition to match values is like
i need to check each value in list 2 if they match with list 2
values in list 2 should be less than or equal value in list 1 to match.but when i say less than i am ranging the each list one value as (x to x-10 with step as 1).(ex. value 354 range will be from 344, 345, 346, 347…354)
value from list 2 will match with list 1 only if its equal or fall in that range
as a result only few of list 2 will match with list 1.
i hope its clear now,
Hi,
this was how i was able to match and get the values …
can any body tell be how else could it be done better.
thank you,