advanced filter with wildcard

[daveyc18]

so i have a bunch of account #s that are 8 numbers (see example below)

common_account_id

40300691

im trying to pick up anything that starts with 403 (first three numbers)

when i try

common_account_id

403#####

the advanced filter doesnt work

 

[shift-del]

Hi d...

Try:
403*

 

[daveyc18]

Hi d...

Try:
403*

i tried but it didn't work ...let me try again

 

[daveyc18]

i tried but it didn't work ...let me try again

Hi d...

Try:
403*

ye unfortunately didn't work

* doesn't work for numbers right ?

 

[RobP]

this ones a bit crude - but you can get the gist if you can use a formula elsewhere in the sheet

Book1
	A	B	C	D	E	F	G
2	40300691	add data here			40300691	add data here
3	40300256	and here			40300256	and here
4	40366587	more stuff			40366587	more stuff
5	40200551	few items			40300000	nothing here
6	40105589	lots here
7	40300000	nothing here
8
Sheet1

Cell Formulas
Range	Formula
E2:F5	E2	=FILTER(A2:B7,A2:A7-40300000>=0)
Dynamic array formulas.

 

[Cubist]

How about

=FILTER(A:A,LEFT(TRIM(A:A),3) = "403")

 

[daveyc18]

tks everyone