Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel 2007: Custom Filter
Hello,
in Excel 2007 the Custom Filter for Number doesnt work with the option ends with Any solution? Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom filter limit removed in 2007? | Excel Discussion (Misc queries) | |||
DataFilterAuto Filter in excel 2007? | New Users to Excel | |||
Excel 2007 Auto Filter Filter | Excel Discussion (Misc queries) | |||
2003 - 2007 custom macro and custom button restore. | Excel Discussion (Misc queries) | |||
How do I set up a custom toolbar in Excel 2007? | Excel Discussion (Misc queries) |