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