Excel 2007: Custom Filter
 

Hello,
in Excel 2007 the Custom Filter for Number doesnt work with the option
€œends with€�

Any solution?

Thanks

Excel 2007: Custom Filter
 

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


"lex" wrote in message
...
Hello,
in Excel 2007 the Custom Filter for Number doesn't work with the option
"ends with"

Any solution?

Thanks