_Excel_FilterSet

[linbin]

I can only display selected values (20, 40 and 60)  with the following code:

 

Local $aShow[] = ["20", "40", "60"]
_Excel_FilterSet($oWorkbook, Default, Default, 2, $aShow, $xlFilterValues)

But how to filter the values which are not (20 , 40 and 60) ?

[Jfish]

That example is from the help file with many other examples.  I you wanted a list of values as in the above example you could just change the numbers: ["1", "2, "3"]

If you want everything less than 100 then you would use "<100".  What are you trying to find specifically?  Is there not an example of that in the help file?