Filter criteria

[gijimbo]

Is it possible to use the excel filter to show only rows where the cell begins with a numeric character?

In other words I want to hide all rows who's 2nd cell begins with an alpha character.

It should also be noted that all values in this column are stored as text.

 

[Aladin Akyurek]

2ad,yad
wad,1ud
z2ad,jad
0qas,kad

Which rows from 2 to 4 above must be shown while the rest is hidden?

 

[Erick]

I don't think you can filter by formula, like you could with condition formatting.

One clunky way to do it is add a new column with a formula
=IF(ISERROR(VALUE(LEFT(A1,1))),FALSE,TRUE)

The you can filter 'TRUE', which are cells that begin with a number.

 

[T. Valko]

Is it possible to use the excel filter to show only rows where the cell begins with a numeric character?

In other words I want to hide all rows who's 2nd cell begins with an alpha character.

It should also be noted that all values in this column are stored as text.

Can you post some data and let us know which rows would be visible once the filter is applied?

 

[gijimbo]

2ad,yad
wad,1ud
z2ad,jad
0qas,kad

Which rows from 2 to 4 above must be shown while the rest is hidden?

2ad,yad - hidden
wad,1ud - visible
z2ad,jad - hidden
0qas,kad - hidden

Can you post some data and let us know which rows would be visible once the filter is applied?

TCO,0612 - visible
_____,AB32 - hidden
X938DG,Q2390 - hidden
X938DG,3458 - visible

Note: Some cells in column 1 will be empty like in row 2 of the example above.

 

[T. Valko]

2ad,yad - hidden
wad,1ud - visible
z2ad,jad - hidden
0qas,kad - hidden



TCO,0612 - visible
_____,AB32 - hidden
X938DG,Q2390 - hidden
X938DG,3458 - visible

Note: Some cells in column 1 will be empty like in row 2 of the example above.

Try something like this...

Book1
	A	B	C
2	Header1	Header2	Header3
3	TCO	0612	TRUE
4		AB32	FALSE
5	X938DG	Q2390	FALSE
6	X938DG	3458	TRUE
Sheet1

Enter this formula in C3 and copy down as needed:

=ISNUMBER(-LEFT(B3))

Then you can filter on column C = TRUE

Book1
	A	B	C
2	Header1	Header2	Header3
3	TCO	0612	TRUE
6	X938DG	3458	TRUE
Sheet1

 

[gijimbo]

That's a good idea. I'll do that.

Thanks to everyone who helped.

 

[T. Valko]

That's a good idea. I'll do that.

Good deal!