I want to filter existing excel L column with NA and empty values but the problem is L1 column has some NA values so actual column starts from L2 cell

[Gopi_Krishna1 (Gopi Krishna)]

I want to filter existing excel L column with NA and empty values but the problem is L1 column has some NA values so actual column starts from L2 cell

[ashokkarale]

@Gopi_Krishna1,

You can use this VBA code to achieve this.

   'Select Range which needs to be filtered
    Range("A1:N6").Select
    Range("L1").Activate
    'Apply Filter on L Column
    Selection.AutoFilter
    ActiveSheet.Range("$A$1:$N$6").AutoFilter Field:=12, Criteria1:="=#N/A", _
        Operator:=xlOr, Criteria2:="="
    Range("L4").Select

This sample I used:

Thanks,
Ashok