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.

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

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