Forum Discussion

AdityaNiranjan's avatar
AdityaNiranjan
Copper Contributor
Oct 03, 2024

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? 

 

 

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    If you format your data as table, you can add a Slicer for each of those three columns and use those to achieve exactly this.

Resources