Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Filter
I am trying to use the filter in a spreadsheet that has around 28,000
rows. I deleted the blanks but I am trying to filter up a range of a certain number and it won't filter it up. It will show it as nothing. Is it because there are too many rows? I am trying to filter up any number that starts with 51* and I use the wildcard but it pulls up nothing. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Filter
wrote in message
oups.com... I am trying to use the filter in a spreadsheet that has around 28,000 rows. I deleted the blanks but I am trying to filter up a range of a certain number and it won't filter it up. It will show it as nothing. Is it because there are too many rows? I am trying to filter up any number that starts with 51* and I use the wildcard but it pulls up nothing. Tips at http://www.contextures.com/xlautofilter02.html -- David Biddulph |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel Filter
Thanks so much, it worked.
David Biddulph wrote: wrote in message oups.com... I am trying to use the filter in a spreadsheet that has around 28,000 rows. I deleted the blanks but I am trying to filter up a range of a certain number and it won't filter it up. It will show it as nothing. Is it because there are too many rows? I am trying to filter up any number that starts with 51* and I use the wildcard but it pulls up nothing. Tips at http://www.contextures.com/xlautofilter02.html -- David Biddulph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel 2007 Beta Advanced Filter Performance | Excel Discussion (Misc queries) | |||
Running Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
Using Excel 2000 VBA Application on Excel 2003 | Excel Worksheet Functions | |||
Excel filter over multiple sheets | Excel Worksheet Functions |