Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

PLEASE HELP !!!

Posted by Sasa on February 05, 2002 5:26 AM

Dear all,
I would like to filer data in column. What should I put in criteria if I want to show only datas which starts with number (ex. 1234, 123jhkjh, 24jhkjh, 87687)
Thanks in advance for any halp.

Check out our Excel Resources

Specifying Criteria for Adv Filter

Posted by Aladin Akyurek on February 05, 2002 5:49 AM

Lets say that A4:B7 houses the following data:

{"Field1","Field2";
"123bcms",1;
"qer3425",2;
"1235jkhi",7}

In A1 enter: CField [ A field label that must be different from those in A4:B4 ]

In A2 enter: =ISNUMBER(LEFT(A5)+0)

Activate A5.
Activate Data|Filter|Advanced Filter.
Specify as List range, e.g., : $A$4:$B$7
Specify as Criteria range: $A$1:$A$2
Check Copy to another location.
Specify a location for Copy to, e.g., $F$1
Click OK.

===========

Re: Specifying Criteria for Adv Filter

Posted by Sasa on February 05, 2002 7:04 AM

Thanks for help, but can you please clarify this little bit more.
What I need is to filter data in column by criteria which is "data contains number in begining (ex. 1321dsfasdf, 2122, 1567ggg)
Thanks.

Re: Specifying Criteria for Adv Filter

Posted by Aladin Akyurek on February 05, 2002 8:24 AM

I don't know what the trouble is. I can only offer a copy of a workbook that shows how what I described works. If inerested in that, drop me a line.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.