This is the way to take the min and max age values from the input.

Formula in column C:

```
={"Min age";ARRAYFORMULA(IF(B2:B<>"",VALUE(SUBSTITUTE(LEFT(B2:B,FIND("-",B2:B)-2),",",".")),""))}
```

Formula in column D:

```
={"Max age";ARRAYFORMULA(IF(B2:B<>"",VALUE(SUBSTITUTE(TRIM((SUBSTITUTE(RIGHT(B2:B,LEN(B2:B)-1-FIND("-",B2:B)+1)," ans",""))),",",".")),""))}
```

However, I encountered a problem with the logic when working with filter comparisons. As of now, we can’t directly compare a value to another column’s value.

I wanted this logic to be Child age (User’s specific input) to be larger than the min age and smaller than the max age, for example, but it was not achieveable.

Hope someone can chime in with another workaround based on the values taken from the age range.