Hi All
I to need filter in more than 2 conditions in same column, I tried advanced filter I didn't get anywhere mainly because my conditions are:
Non Blank
Does Not Begin With
Does Not End With
Does Not Contain
I don't how to make these conditions in advanced filter at the same time.
I tried recording a macro and editing but no joy. I am using the following code.
Any suggestions please?
Many Thanks
Genzz
I to need filter in more than 2 conditions in same column, I tried advanced filter I didn't get anywhere mainly because my conditions are:
Non Blank
Does Not Begin With
Does Not End With
Does Not Contain
I don't how to make these conditions in advanced filter at the same time.
I tried recording a macro and editing but no joy. I am using the following code.
Code:
Sub Filter3()
Range("A8").Select
Selection.AutoFilter
Selection.AutoFilter Field:=29, Criteria1:="<>", Criteria2:="<>^*", _
Criteria3:="<>*^", Criteria4:="<>*^^*"
Range("A8").Select
End Sub
Any suggestions please?
Many Thanks
Genzz