Applying filter to an excel sheet from an array

[Jess 1]

Hi,

I am trying to apply filter to an excel sheet from another excel sheet. I am storing the set of filters to be applied in an array and apply the filter to the excel sheet. The set of filters contains alphanumeric numbers and a number. When I run the script it is working fine and applying filters. The problem in applying filters is that it  does not take into consideration the number in array, but only the other texts in array.

Can someone guide me as to why is this happening.

 

Thank You.

[water 2,187]

Can you post a reproducer script/Excel file so we can play with it?

[Jess 1]

Hi @water.

I played around after posting this query and I was able to make up. The issue was that I was storing the number as text. In the second sheet where I need to apply filter , it was other way around.

Now it is working fine.

Thanks

[water 2,187]