Am I right in assuming that the first 5 digits of the 7 digit numbers are not
in the same range and that is why you can only use the last 2 digits? If they
are in the same range then you can simply custom filter on the entire number
as per the following example:-

If my assumption is correct and you cannot use the above, I suggest that you
add a column and insert this formula and copy it down for the entire length
of data:-

=VALUE(RIGHT(A2,2))     where A2 is the 7 digit number.

You can then use AutoFilter and set a Custom filter to Greater than of equal
to AND Less than or equal to.

If you need to copy and paste the filtered data, the range of visible cells
should copy and paste without the non visible cells. However, there have been
reports of people having problems doing this and all the cells copy. If you
experience this problem, then select the range of visible cells and then
Edit-> Goto and click Special in the bottom left of dialog box then select
visible cells only. Close the dialog box and then click copy.

Regards,

OssieMac

One way would be with a helper column to filter on.
=LOOKUP(RIGHT(H2,2),{"00","34","67"},{1,2,3})
or
=LOOKUP(RIGHT(H6,2),{"00","34","67"},{"Jay","Bill","Jim"})