Excel 2007: Custom Filter

[lex]

Hello,
in Excel 2007 the Custom Filter for Number doesn’t work with the option
“ends withâ€

Any solution?

Thanks

 

[Bernie Deitrick]

Lex,

Use a helper column of formulas to extract the 'end' of the number:

For one digit:
=MOD(A2,10)

For 2 digits:

=MOD(A2,100)


etc....

Then based the CF on those cells.

HTH,
Bernie
MS Excel MVP