autofilter

bill151515

Board Regular
Joined
May 19, 2005
Messages
87
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????
 

Some videos you may like

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).

BrianB

Well-known Member
Joined
Feb 17, 2003
Messages
8,127
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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,088
Messages
5,570,147
Members
412,306
Latest member
fabio6
Top