autofilter

[bill151515]

is there a way to run a macro that autofilters a column where the first cell is a header the filter criteria would be the first character of the cells being a 3????

 

[BrianB]

If the character is text you can have a Custom autofilter with the "first character =3".

If it is a number you will probably need another column with a formula like :-
=IF(LEFT(TEXT(A2,"#.00"),1)="3",1,0)

Record a macro of the Autofilter process