Filter option for business user for a value range

Hi,

i do have trouble implementing implenting a filter. I want the to give the business user the chance to filter for a value range.

the column looks like:

x001
x002
x003

y001
y002

z001

At the moment there is a button dopdown - but there is the need to look up a range, e.g. x050-x080 which are to many values to be selected manually.

My idea was to let the user set the minimum and maximum value via input fields and use those values as a sheet filter but variables can not be used in sheet filters.

Does someone have an idea?

Best regards,
Jan