PDA

View Full Version : "Begins with" Filters for Number Columns?



prabhafriend
10-12-2010, 05:32 AM
How to do "Begins with" Filters for Number Columns through Code. Like to list the numbers starts with 22. I know we can do manually by using Text-to-Columns. But my question is how to do it programmatically? Urgent help needed.

Kenneth Hobs
10-12-2010, 07:14 PM
If you can do it manually, record a macro to get the syntax.

I would just use a helper column and sort by True. For B2: =MOD(VALUE(LEFT(TEXT(A4,"00"),2)),22)=0