Number hunting...

[rurog]

I have a list of a couple of hundred numbers in a column, they look like this: 123456 - 12345.
I need to filter the numbers that are ****01-*****, ****00-*****, ****99-*****, ****98-*****, ****97-***** and so on (counting).
Meaning I want to remove any numbers that have 02, 03, 04, 05, 06, 07, 08, 09, 10 in the fifth and sixth place.

There must be some way to fix this, and I have tried google, but I can't seem to find the proper English term to search for.

Can anyone help me by either telling be how to do it, or giving me the name of what I'm looking for?

Thanks!

[kasan]

Hi and welcome!
You can extract numbers you wish first. If your code 123456-12345 is in cell A1, then B1 formula:

Please Login or Register  to view this content.

This will return '56', drag formula down and then filter out your 02, 03 ...

[rurog]

Hi and thank you for your quick reply!

[FlameRetired]

As an alternative you could also modify kasan's formula as

=OR(MID(A1,5,2)={"02","03","04","05","06","07","08","09","10"})

and filter out TRUE.

Note that the numbers are in quotes since source data is text and the output of the MID function is text.