Directly filter sheet with array of values not storing values in datatable and not using vba

Help Activities
1

Hello everyone,

I want to filter the Excel sheet I have the values stored in array by which I want to filter. I don’t want to use either datatable filters or VBA for the same

I want to do it apply filter directly on sheet with array of values please let me know how to do it and if possible how to apply array of values to filter activity

2

@Datta7799

Use a for loop on array and then use filter inside the loop to apply each value

Cheers

3

One way is As Anil mentioned above, you can use For loop. The other way is you can use FILTER formula in excel .

Example: =FILTER(Table1, (A:A=“X”) * (B:B=“Y”) * (C:C=“Z”) * (D:D>100) *(E:E<50))

Table1 is the range of your entire data. And as per your filter requirement needs, you can modify the above formula

Filter Formula
Filter Formula777×130 1.56 KB