I’m trying, how to use Not Equal to in filter options of filter table activity.
But there’s an alternate option, which is recording a macro in excel and use it by using Invoke VBA activity
here’s the Example code,
ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=5, Criteria1:= _
This worked well.
but, as you can see I’ve used “<>A2” but while using <> in filter option it’s giving error.
So using recording macro by clicking on,
- column filter.
- text filters.
- Does Not Equal to
and then give value as A2, click OK.
So this could be alternate option.