Forum Discussion
AdityaNiranjan
Oct 03, 2024Copper Contributor
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?
- JKPieterseSilver ContributorIf you format your data as table, you can add a Slicer for each of those three columns and use those to achieve exactly this.