Archive of Mr Excel Message Board
Back to Data in Excel archive index
Back to archive home
Advanced filter !!!
Posted by Sasa on February 05, 2002 2:52 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.
Posted by Aladin Akyurek on February 05, 2002 6:28 AM
Re: Advanced filter !!!
Posted by Excel Prince on February 05, 2002 8:04 AM
Try this: keep data as text and check criteria >="0" and <":"
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.