How do I create dual sliders to filter data?
Hello,
Is there a way to create dual slider filters?
For example, if I have 3 columns with 100 rows each with numbers 1 to 100, I want to filter the rows using sliders (or if there is better way, please suggest) which meet the following criteria:
Column 1: numbers between 30-70
Column 2: numbers between 50-85
Column 3: numbers between 40-55
Once the sliders are selected, I want the rows which match all three of the criteria shown above to be displayed.
Is there a way to do this in Excel?
Hello, Is there a way to create dual slider filters? For example, if I have 3 columns with 100 rows each with numbers 1 to 100, I want to filter the rows using sliders (or if there is better way, please suggest) which meet the following criteria:Column 1: numbers between 30-70Column 2: numbers between 50-85Column 3: numbers between 40-55Once the sliders are selected, I want the rows which match all three of the criteria shown above to be displayed. Is there a way to do this in Excel? Read More