#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Custom Autofilter

I am trying to filter for all part numbers beginning with 96745. The full numbers would be 9674528, 9674534,
etc. Following the dialogs under autofilter and custom, I select "begins with" and enter 96745. But after
clicking ok the screen is blank, no records are found. What am I missing here?


--
--------------------------------- --- -- -
Posted with NewsLeecher v3.8 Beta 6
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -

  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 620
Default Custom Autofilter

Have you got spaces (or other non-visible characters) before your numbers?
If in doubt, try a formula such as =LEFT(A1,5) to check what your numbers do
start with.
--
David Biddulph

"flumpf" wrote in message
...
I am trying to filter for all part numbers beginning with 96745. The full
numbers would be 9674528, 9674534,
etc. Following the dialogs under autofilter and custom, I select "begins
with" and enter 96745. But after
clicking ok the screen is blank, no records are found. What am I missing
here?



  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 196
Default Custom Autofilter

Autofilter won't work for me in this way if the part numbers are
genuine numerics - I presume this will be the case for you also.

Assuming this is the case, and that conversion to Text of these part
nos won't cause you an issue, then you can select the part nos column,
go DataTextToColumns and when the dialog opens, click next, click
Next again and select the Column Data Format to be Text. Now you can
use "Begins With" in autofilter.

Hope this helps!

Richard


On 22 Feb, 04:37, flumpf ) wrote:
I am trying to filter for all part numbers beginning with 96745. The full numbers would be 9674528, 9674534,
etc. Following the dialogs under autofilter and custom, I select "begins with" and enter 96745. But after
clicking ok the screen is blank, no records are found. What am I missing here?

--
--------------------------------- --- -- -
Posted with NewsLeecher v3.8 Beta 6
Web @http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Custom Autofilter

Or you could insert a helper column and convert the real numbers to text (that
looks like numbers).

Either
=a2&""
or
=text(a2,"000000000")
if you want to preserve leading 0's

Then filter by that helper column.

" wrote:

I am trying to filter for all part numbers beginning with 96745. The full numbers would be 9674528, 9674534,
etc. Following the dialogs under autofilter and custom, I select "begins with" and enter 96745. But after
clicking ok the screen is blank, no records are found. What am I missing here?

--
--------------------------------- --- -- -
Posted with NewsLeecher v3.8 Beta 6
Web @ http://www.newsleecher.com/?usenet
------------------- ----- ---- -- -


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
custom autofilter in excel custom autofilter in excel Excel Worksheet Functions 9 December 21st 06 10:38 AM
Custom AutoFilter Rocky Excel Worksheet Functions 4 August 10th 06 05:02 PM
Can I use more than two conditions in custom autofilter? Chris M Excel Worksheet Functions 2 July 6th 06 09:17 PM
custom autofilter dropdown Anubis Setting up and Configuration of Excel 1 June 25th 06 09:16 AM
Custom Autofilter List Alex Lush Excel Discussion (Misc queries) 1 April 18th 05 07:47 PM


All times are GMT +1. The time now is 02:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"