Archive of Mr Excel Message Board
Back to Data in Excel archive index
Back to archive home
filtering dataPosted by Maarten on January 13, 2000 2:07 PM
I have a sheet with a large quantaty of data and in a colum I only want to show values that end with a 1 or a 6.
If I use autofilter it doesn't show any thing.
used the option of "ends with" but still nothing.
Re: filtering dataPosted by Celia on January 13, 2000 5:35 PM
I also can often not get the autofilter or advanced filter to do what they are supposed to do and normally have to write macros instead.
Unless someone can explain how to do what you want by using Excel's filter tool, you could use the following macro.
Dim cell As Range
For Each cell In Selection
If Right(cell.Value, 1) <> 1 And Right _ (cell.Value, 1) <> 6 Then
cell.EntireRow.Hidden = True
Re: filtering dataPosted by Maarten on January 14, 2000 12:00 AM
EXCELENT, you just saved me hours of work.
Thanks a lot for that.
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.