Sleeper: AdvancedFilter - Unique Column 1, Greater than 0 Column 3

[tlong]

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.

[p45cal]

If duplicate values in column A have several different positive values in column C, which one do you want to see?

[tlong]

Hi p45cal,
If column A is duplicated then records in column C always has the same exact repeated values so it's ok to hide entire repeating rows.

Thanks

[p45cal]

Can you supply a workbook with typical data in for this, with expected results too?