Forum Discussion

berryck's avatar
berryck
Copper Contributor
Dec 13, 2023
Solved

Return rows from a table based on a numeric value

I'm trying to filter tables based on a numeric value entered by a user. Here's what I'm trying to do:   Hopefully that makes sense.   
excel
Formulas and Functions
  • Patrick2788's avatar
    Patrick2788
    Dec 13, 2023

    berryck 

    Try this one:

    =LET(
    low, 1 * TEXTBEFORE(Table1[Range], "-"),
    high, 1 * TEXTAFTER(Table1[Range], "-"),
    FILTER(Table1, (input >= low) * (input <= high), "None found")
)
mtarler's avatar
mtarler
Silver Contributor
Dec 13, 2023
Break column B in to 2 columns: min and max and then use FILTER(... , A2>=minCol, A2<=maxCol, "") Otherwise you need to apply text manipulation to break that text value 20-40 into those 2 columns I mention above.

Resources