Hi All,
Is there a way thru vba to filter column B to only show:
-All items that does not begin with "2009INV"
and
-Only unique items
I can do advanced filtering formula criteria (=AND(LEFT(B2,4)<>"2009",COUNTIF($B$2:B2,B2)<2)) but when I tried to record it thru macro, it just specifies the criteria range (not the formula underneath it). The criteria range is not a fixed range.
Thanks
Is there a way thru vba to filter column B to only show:
-All items that does not begin with "2009INV"
and
-Only unique items
I can do advanced filtering formula criteria (=AND(LEFT(B2,4)<>"2009",COUNTIF($B$2:B2,B2)<2)) but when I tried to record it thru macro, it just specifies the criteria range (not the formula underneath it). The criteria range is not a fixed range.
Thanks