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
|