Excel 2007: Custom Filter

  • Thread starter Thread starter lex
  • Start date Start date
L

lex

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

Any solution?

Thanks
 
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
 
Back
Top