Filter datatable by blanks

hey @NiranjanKN,

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,

Sub Macro1()

    ActiveSheet.ListObjects("Table1").Range.AutoFilter Field:=5, Criteria1:= _
        "<>A2", Operator:=xlAnd
End Sub

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,

  1. column filter.
  2. text filters.
  3. Does Not Equal to
    and then give value as A2, click OK.

So this could be alternate option. :slightly_smiling_face: