tlong
10-29-2019, 09:54 PM
Hi VBA guru,
I need little help with combination of AdvancedFilter or a similar option to filter mult criteria.
I need to Filter/Hide column C to only show value greater than Zero and Hide duplication from column A.
I'm currently using this following to hide duplication.
Sub FilterDup()
Range("A5:A1000").Select
Range("A5:A1000").AdvancedFilter Action:=xlFilterInPlace, Unique:=True
Range("A1").Select
End Sub
Much appreciated for your time.
I need little help with combination of AdvancedFilter or a similar option to filter mult criteria.
I need to Filter/Hide column C to only show value greater than Zero and Hide duplication from column A.
I'm currently using this following to hide duplication.
Sub FilterDup()
Range("A5:A1000").Select
Range("A5:A1000").AdvancedFilter Action:=xlFilterInPlace, Unique:=True
Range("A1").Select
End Sub
Much appreciated for your time.