advanced filter, but only pick up security ID that doesnt start with a number

[daveyc18]

so i want to filter data, but i only want sec. ID that begins with a letter (or in other words, not a number).

 

[Joe4]

You could use a "helper" column, to determine if it starts with a number or not, like this (for an ID in cell A2):
=ISNUMBER(LEFT(A2,1)+0)
Ones that start with a number will return TRUE, and ones that don't will return FALSE, and then you can use this column to filter on.

 

[Peter_SSs]

Since you are apparently using Advanced Filter, it depends on how you are doing the Adv Filter. That is
- manual or vba
- Headings with criteria or a no-heading formula approach?

Here is an example of a no-heading formula approach.
Formula as shown goes anywhere that has a vacant cells above it. note that the formula points to the first data cell in the sec. ID column only.

A_MrExcel.xlsm
	C	D	E	F	G	H
1
2						FALSE
3
4	Hdr 1	sec. ID	Hdr 3	Hdr 4
5	data	3824	data	data
6	data	H35	data	data
7	data	65025	data	data
8	data	XD87865R	data	data
Adv Fltr

Cell Formulas
Range	Formula
H2	H2	=NOT(ISNUMBER(LEFT(D5,1)+0))

Then do an Advanced Filter on the range C4:F8 with a criteria range of H1:H2. Result:

A_MrExcel.xlsm
	C	D	E	F	G	H
1
2						FALSE
3
4	Hdr 1	sec. ID	Hdr 3	Hdr 4
6	data	H35	data	data
8	data	XD87865R	data	data
9
Adv Fltr

Cell Formulas
Range	Formula
H2	H2	=NOT(ISNUMBER(LEFT(D5,1)+0))

 

[daveyc18]

was

using VBA advanced filter relying on headers

 

[Peter_SSs]

using VBA advanced filter relying on headers

In that case could we see the code you are currently using and some sample data so we can see the layout and where/how you are using those headers in your criteria?